eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_COMMON_PVT dependencies on FND_GLOBAL

Line 3272: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

3268: OZF_RESALE_ADJUSTMENTS_PKG.Insert_Row(
3269: px_resale_adjustment_id => l_adjustment_id,
3270: px_object_version_number => l_obj_ver_num,
3271: p_last_update_date => sysdate,
3272: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3273: p_creation_date => sysdate,
3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3276: p_created_from => p_price_adj_rec.created_from,

Line 3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

3270: px_object_version_number => l_obj_ver_num,
3271: p_last_update_date => sysdate,
3272: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3273: p_creation_date => sysdate,
3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3276: p_created_from => p_price_adj_rec.created_from,
3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

Line 3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),

3271: p_last_update_date => sysdate,
3272: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3273: p_creation_date => sysdate,
3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3276: p_created_from => p_price_adj_rec.created_from,
3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3279: p_program_update_date => sysdate,

Line 3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

3273: p_creation_date => sysdate,
3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3276: p_created_from => p_price_adj_rec.created_from,
3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3279: p_program_update_date => sysdate,
3280: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3281: p_resale_line_id => p_price_adj_rec.resale_line_id,

Line 3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

3274: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3275: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3276: p_created_from => p_price_adj_rec.created_from,
3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3279: p_program_update_date => sysdate,
3280: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3281: p_resale_line_id => p_price_adj_rec.resale_line_id,
3282: p_resale_batch_id => p_price_adj_rec.resale_batch_id,

Line 3280: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

3276: p_created_from => p_price_adj_rec.created_from,
3277: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3278: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3279: p_program_update_date => sysdate,
3280: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3281: p_resale_line_id => p_price_adj_rec.resale_line_id,
3282: p_resale_batch_id => p_price_adj_rec.resale_batch_id,
3283: p_orig_system_agreement_uom => p_price_adj_rec.orig_system_agreement_uom,
3284: p_orig_system_agreement_name => p_price_adj_rec.orig_system_agreement_name,

Line 4332: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

4328: OZF_RESALE_HEADERS_PKG.Insert_Row(
4329: px_resale_header_id => l_header_id,
4330: px_object_version_number => l_object_version_number,
4331: p_last_update_date => SYSdate,
4332: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4333: p_creation_date => SYSdate,
4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

Line 4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

4330: px_object_version_number => l_object_version_number,
4331: p_last_update_date => SYSdate,
4332: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4333: p_creation_date => SYSdate,
4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4338: p_program_update_date => SYSdate,

Line 4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),

4331: p_last_update_date => SYSdate,
4332: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4333: p_creation_date => SYSdate,
4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4338: p_program_update_date => SYSdate,
4339: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

4332: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4333: p_creation_date => SYSdate,
4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4338: p_program_update_date => SYSdate,
4339: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4340: p_created_from => p_line_int_rec.created_from,

Line 4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

4333: p_creation_date => SYSdate,
4334: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4338: p_program_update_date => SYSdate,
4339: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4340: p_created_from => p_line_int_rec.created_from,
4341: p_date_shipped => p_line_int_rec.date_shipped,

Line 4339: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

4335: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4336: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4337: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4338: p_program_update_date => SYSdate,
4339: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4340: p_created_from => p_line_int_rec.created_from,
4341: p_date_shipped => p_line_int_rec.date_shipped,
4342: p_date_ordered => p_line_int_rec.date_ordered,
4343: p_order_type_id => p_line_int_rec.order_type_id,

Line 4546: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

4542: p_resale_header_id => p_header_id ,
4543: p_resale_transfer_type => p_line_int_rec.resale_transfer_type ,
4544: px_object_version_number => l_obj_ver_num,
4545: p_last_update_date => SYSdate,
4546: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4547: p_creation_date => SYSdate,
4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

Line 4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

4544: px_object_version_number => l_obj_ver_num,
4545: p_last_update_date => SYSdate,
4546: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4547: p_creation_date => SYSdate,
4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4552: p_program_update_date => SYSdate,

Line 4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),

4545: p_last_update_date => SYSdate,
4546: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4547: p_creation_date => SYSdate,
4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4552: p_program_update_date => SYSdate,
4553: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

4546: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4547: p_creation_date => SYSdate,
4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4552: p_program_update_date => SYSdate,
4553: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4554: p_created_from => p_line_int_rec.created_from,

Line 4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

4547: p_creation_date => SYSdate,
4548: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4552: p_program_update_date => SYSdate,
4553: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4554: p_created_from => p_line_int_rec.created_from,
4555: p_status_code => G_BATCH_ADJ_PROCESSED ,

Line 4553: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

4549: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4550: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4551: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4552: p_program_update_date => SYSdate,
4553: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4554: p_created_from => p_line_int_rec.created_from,
4555: p_status_code => G_BATCH_ADJ_PROCESSED ,
4556: p_product_trans_movement_type => p_line_int_rec.product_transfer_movement_type ,
4557: p_product_transfer_date => p_line_int_rec.product_transfer_date,

Line 4869: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

4865: p_resale_batch_id => p_resale_batch_id,
4866: p_resale_line_id => p_line_id,
4867: px_object_version_number => l_obj_ver_num,
4868: p_last_update_date => SYSdate,
4869: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4870: p_creation_date => SYSdate,
4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

Line 4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

4867: px_object_version_number => l_obj_ver_num,
4868: p_last_update_date => SYSdate,
4869: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4870: p_creation_date => SYSdate,
4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4875: p_program_update_date => SYSdate,

Line 4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),

4868: p_last_update_date => SYSdate,
4869: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4870: p_creation_date => SYSdate,
4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4875: p_program_update_date => SYSdate,
4876: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

4869: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4870: p_creation_date => SYSdate,
4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4875: p_program_update_date => SYSdate,
4876: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4877: p_created_from => NULL,

Line 4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

4870: p_creation_date => SYSdate,
4871: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4875: p_program_update_date => SYSdate,
4876: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4877: p_created_from => NULL,
4878: p_attribute_category => NULL,

Line 4876: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

4872: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4873: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4874: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4875: p_program_update_date => SYSdate,
4876: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4877: p_created_from => NULL,
4878: p_attribute_category => NULL,
4879: p_attribute1 => NULL,
4880: p_attribute2 => NULL,

Line 6915: LAST_UPDATED_BY = NVL (fnd_global.user_id, -1),

6911: ROLLUP_PAID_AMT = NVL(ROLLUP_PAID_AMT,0) + NVL(funds_int_rec.ROLLUP_PAID_AMT,0),
6912: UTILIZED_AMT = NVL(UTILIZED_AMT,0) + NVL(funds_int_rec.UTILIZED_AMT,0),
6913: ROLLUP_UTILIZED_AMT = NVL(ROLLUP_UTILIZED_AMT,0) + NVL(funds_int_rec.ROLLUP_UTILIZED_AMT,0),
6914: LAST_UPDATE_DATE = SYSDATE,
6915: LAST_UPDATED_BY = NVL (fnd_global.user_id, -1),
6916: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
6917: WHERE FUND_ID = funds_int_rec.fund_id;
6918:
6919: -- Updating the fund tl tables.

Line 6922: ,last_updated_by = NVL(fnd_global.user_id, -1)

6918:
6919: -- Updating the fund tl tables.
6920: UPDATE ozf_funds_all_tl
6921: SET last_update_date = SYSDATE
6922: ,last_updated_by = NVL(fnd_global.user_id, -1)
6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
6924: ,request_id = fnd_global.conc_request_id
6925: ,program_application_id = fnd_global.prog_appl_id
6926: ,program_id = fnd_global.conc_program_id

Line 6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)

6919: -- Updating the fund tl tables.
6920: UPDATE ozf_funds_all_tl
6921: SET last_update_date = SYSDATE
6922: ,last_updated_by = NVL(fnd_global.user_id, -1)
6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
6924: ,request_id = fnd_global.conc_request_id
6925: ,program_application_id = fnd_global.prog_appl_id
6926: ,program_id = fnd_global.conc_program_id
6927: ,program_update_date = SYSDATE

Line 6924: ,request_id = fnd_global.conc_request_id

6920: UPDATE ozf_funds_all_tl
6921: SET last_update_date = SYSDATE
6922: ,last_updated_by = NVL(fnd_global.user_id, -1)
6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
6924: ,request_id = fnd_global.conc_request_id
6925: ,program_application_id = fnd_global.prog_appl_id
6926: ,program_id = fnd_global.conc_program_id
6927: ,program_update_date = SYSDATE
6928: WHERE fund_id = funds_int_rec.fund_id

Line 6925: ,program_application_id = fnd_global.prog_appl_id

6921: SET last_update_date = SYSDATE
6922: ,last_updated_by = NVL(fnd_global.user_id, -1)
6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
6924: ,request_id = fnd_global.conc_request_id
6925: ,program_application_id = fnd_global.prog_appl_id
6926: ,program_id = fnd_global.conc_program_id
6927: ,program_update_date = SYSDATE
6928: WHERE fund_id = funds_int_rec.fund_id
6929: AND USERENV('LANG') IN(language, source_lang);

Line 6926: ,program_id = fnd_global.conc_program_id

6922: ,last_updated_by = NVL(fnd_global.user_id, -1)
6923: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
6924: ,request_id = fnd_global.conc_request_id
6925: ,program_application_id = fnd_global.prog_appl_id
6926: ,program_id = fnd_global.conc_program_id
6927: ,program_update_date = SYSDATE
6928: WHERE fund_id = funds_int_rec.fund_id
6929: AND USERENV('LANG') IN(language, source_lang);
6930:

Line 6980: ,last_updated_by = NVL (fnd_global.user_id, -1)

6976: ,approved_original_amount = NVL(approved_original_amount, 0) + NVL(budgets_int_rec.APPROVED_ORIGINAL_AMOUNT,0)
6977: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(budgets_int_rec.APPROVED_AMOUNT_FC,0)
6978: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(budgets_int_rec.parent_src_apprvd_amt,0)
6979: ,last_update_date = sysdate
6980: ,last_updated_by = NVL (fnd_global.user_id, -1)
6981: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
6982: ,object_version_number = NVL (object_version_number,0) + 1
6983: WHERE activity_budget_id = budgets_int_rec.ACTIVITY_BUDGET_ID;
6984:

Line 6981: ,last_update_login = NVL (fnd_global.conc_login_id, -1)

6977: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(budgets_int_rec.APPROVED_AMOUNT_FC,0)
6978: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(budgets_int_rec.parent_src_apprvd_amt,0)
6979: ,last_update_date = sysdate
6980: ,last_updated_by = NVL (fnd_global.user_id, -1)
6981: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
6982: ,object_version_number = NVL (object_version_number,0) + 1
6983: WHERE activity_budget_id = budgets_int_rec.ACTIVITY_BUDGET_ID;
6984:
6985: ozf_utility_pvt.write_conc_log('Updating ozf_act_budgets record ' || budgets_int_rec.ACTIVITY_BUDGET_ID);

Line 7185: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7181: WHEN MATCHED THEN
7182: UPDATE
7183: SET ovolsum.GROUP_VOLUME = ovolsum.GROUP_VOLUME + nvl(ovolgrpint.GROUP_VOLUME,0),
7184: LAST_UPDATE_DATE = SYSDATE,
7185: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7186: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7187: WHEN NOT MATCHED THEN
7188: INSERT
7189: (

Line 7186: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7182: UPDATE
7183: SET ovolsum.GROUP_VOLUME = ovolsum.GROUP_VOLUME + nvl(ovolgrpint.GROUP_VOLUME,0),
7184: LAST_UPDATE_DATE = SYSDATE,
7185: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7186: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7187: WHEN NOT MATCHED THEN
7188: INSERT
7189: (
7190: ovolsum.volume_summary_id

Line 7205: ,FND_GLOBAL.user_id

7201: VALUES
7202: (
7203: ozf_volume_summary_s.NEXTVAL
7204: ,SYSDATE
7205: ,FND_GLOBAL.user_id
7206: ,SYSDATE
7207: ,FND_GLOBAL.user_id
7208: ,FND_GLOBAL.conc_login_id
7209: ,ovolgrpint.OFFER_ID

Line 7207: ,FND_GLOBAL.user_id

7203: ozf_volume_summary_s.NEXTVAL
7204: ,SYSDATE
7205: ,FND_GLOBAL.user_id
7206: ,SYSDATE
7207: ,FND_GLOBAL.user_id
7208: ,FND_GLOBAL.conc_login_id
7209: ,ovolgrpint.OFFER_ID
7210: ,ovolgrpint.GROUP_NO
7211: ,ovolgrpint.GROUP_VOLUME

Line 7208: ,FND_GLOBAL.conc_login_id

7204: ,SYSDATE
7205: ,FND_GLOBAL.user_id
7206: ,SYSDATE
7207: ,FND_GLOBAL.user_id
7208: ,FND_GLOBAL.conc_login_id
7209: ,ovolgrpint.OFFER_ID
7210: ,ovolgrpint.GROUP_NO
7211: ,ovolgrpint.GROUP_VOLUME
7212: ,ovolgrpint.PBH_LINE_ID

Line 7232: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7228: WHEN MATCHED THEN
7229: UPDATE
7230: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7231: LAST_UPDATE_DATE = SYSDATE,
7232: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7233: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7234: WHEN NOT MATCHED THEN
7235: INSERT
7236: (

Line 7233: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7229: UPDATE
7230: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7231: LAST_UPDATE_DATE = SYSDATE,
7232: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7233: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7234: WHEN NOT MATCHED THEN
7235: INSERT
7236: (
7237: ovolsum.volume_summary_id

Line 7252: ,FND_GLOBAL.user_id

7248: VALUES
7249: (
7250: ozf_volume_summary_s.NEXTVAL
7251: ,SYSDATE
7252: ,FND_GLOBAL.user_id
7253: ,SYSDATE
7254: ,FND_GLOBAL.user_id
7255: ,FND_GLOBAL.conc_login_id
7256: ,ovolindint.OFFER_ID

Line 7254: ,FND_GLOBAL.user_id

7250: ozf_volume_summary_s.NEXTVAL
7251: ,SYSDATE
7252: ,FND_GLOBAL.user_id
7253: ,SYSDATE
7254: ,FND_GLOBAL.user_id
7255: ,FND_GLOBAL.conc_login_id
7256: ,ovolindint.OFFER_ID
7257: ,ovolindint.INDIVIDUAL_TYPE
7258: ,ovolindint.INDIVIDUAL_VOLUME

Line 7255: ,FND_GLOBAL.conc_login_id

7251: ,SYSDATE
7252: ,FND_GLOBAL.user_id
7253: ,SYSDATE
7254: ,FND_GLOBAL.user_id
7255: ,FND_GLOBAL.conc_login_id
7256: ,ovolindint.OFFER_ID
7257: ,ovolindint.INDIVIDUAL_TYPE
7258: ,ovolindint.INDIVIDUAL_VOLUME
7259: ,ovolindint.PBH_LINE_ID

Line 7279: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7275: WHEN MATCHED THEN
7276: UPDATE
7277: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7278: LAST_UPDATE_DATE = SYSDATE,
7279: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7280: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7281: WHEN NOT MATCHED THEN
7282: INSERT
7283: (

Line 7280: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7276: UPDATE
7277: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7278: LAST_UPDATE_DATE = SYSDATE,
7279: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7280: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7281: WHEN NOT MATCHED THEN
7282: INSERT
7283: (
7284: ovolsum.volume_summary_id

Line 7300: ,FND_GLOBAL.user_id

7296: VALUES
7297: (
7298: ozf_volume_summary_s.NEXTVAL
7299: ,SYSDATE
7300: ,FND_GLOBAL.user_id
7301: ,SYSDATE
7302: ,FND_GLOBAL.user_id
7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID

Line 7302: ,FND_GLOBAL.user_id

7298: ozf_volume_summary_s.NEXTVAL
7299: ,SYSDATE
7300: ,FND_GLOBAL.user_id
7301: ,SYSDATE
7302: ,FND_GLOBAL.user_id
7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID
7305: ,ovolindint.INDIVIDUAL_TYPE
7306: ,ovolindint.INDIVIDUAL_ID

Line 7303: ,FND_GLOBAL.conc_login_id

7299: ,SYSDATE
7300: ,FND_GLOBAL.user_id
7301: ,SYSDATE
7302: ,FND_GLOBAL.user_id
7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID
7305: ,ovolindint.INDIVIDUAL_TYPE
7306: ,ovolindint.INDIVIDUAL_ID
7307: ,ovolindint.INDIVIDUAL_VOLUME

Line 7324: last_updated_by = NVL(fnd_global.user_id, -1),

7320: ozf_utility_pvt.write_conc_log('updating batch to Closed status - resale_batch_id: ' || batch_id_int_rec.RESALE_BATCH_ID);
7321:
7322: UPDATE ozf_resale_batches_all
7323: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
7324: last_updated_by = NVL(fnd_global.user_id, -1),
7325: last_update_date = SYSDATE
7326: WHERE resale_batch_id = batch_id_int_rec.RESALE_BATCH_ID
7327: AND status_code in ('PENDING_CLOSE','PENDING_ACCRUALS');
7328: END LOOP;

Line 7403: LAST_UPDATED_BY = NVL (fnd_global.user_id, -1),

7399: ROLLUP_PAID_AMT = NVL(ROLLUP_PAID_AMT,0) + NVL(funds_int_rec2.ROLLUP_PAID_AMT,0),
7400: UTILIZED_AMT = NVL(UTILIZED_AMT,0) + NVL(funds_int_rec2.UTILIZED_AMT,0),
7401: ROLLUP_UTILIZED_AMT = NVL(ROLLUP_UTILIZED_AMT,0) + NVL(funds_int_rec2.ROLLUP_UTILIZED_AMT,0),
7402: LAST_UPDATE_DATE = SYSDATE,
7403: LAST_UPDATED_BY = NVL (fnd_global.user_id, -1),
7404: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
7405: WHERE FUND_ID = funds_int_rec2.FUND_ID;
7406:
7407: -- Updating the fund tl tables.

Line 7410: ,last_updated_by = NVL(fnd_global.user_id, -1)

7406:
7407: -- Updating the fund tl tables.
7408: UPDATE ozf_funds_all_tl
7409: SET last_update_date = SYSDATE
7410: ,last_updated_by = NVL(fnd_global.user_id, -1)
7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
7412: ,request_id = fnd_global.conc_request_id
7413: ,program_application_id = fnd_global.prog_appl_id
7414: ,program_id = fnd_global.conc_program_id

Line 7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)

7407: -- Updating the fund tl tables.
7408: UPDATE ozf_funds_all_tl
7409: SET last_update_date = SYSDATE
7410: ,last_updated_by = NVL(fnd_global.user_id, -1)
7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
7412: ,request_id = fnd_global.conc_request_id
7413: ,program_application_id = fnd_global.prog_appl_id
7414: ,program_id = fnd_global.conc_program_id
7415: ,program_update_date = SYSDATE

Line 7412: ,request_id = fnd_global.conc_request_id

7408: UPDATE ozf_funds_all_tl
7409: SET last_update_date = SYSDATE
7410: ,last_updated_by = NVL(fnd_global.user_id, -1)
7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
7412: ,request_id = fnd_global.conc_request_id
7413: ,program_application_id = fnd_global.prog_appl_id
7414: ,program_id = fnd_global.conc_program_id
7415: ,program_update_date = SYSDATE
7416: WHERE fund_id = funds_int_rec2.FUND_ID

Line 7413: ,program_application_id = fnd_global.prog_appl_id

7409: SET last_update_date = SYSDATE
7410: ,last_updated_by = NVL(fnd_global.user_id, -1)
7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
7412: ,request_id = fnd_global.conc_request_id
7413: ,program_application_id = fnd_global.prog_appl_id
7414: ,program_id = fnd_global.conc_program_id
7415: ,program_update_date = SYSDATE
7416: WHERE fund_id = funds_int_rec2.FUND_ID
7417: AND USERENV('LANG') IN(language, source_lang);

Line 7414: ,program_id = fnd_global.conc_program_id

7410: ,last_updated_by = NVL(fnd_global.user_id, -1)
7411: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
7412: ,request_id = fnd_global.conc_request_id
7413: ,program_application_id = fnd_global.prog_appl_id
7414: ,program_id = fnd_global.conc_program_id
7415: ,program_update_date = SYSDATE
7416: WHERE fund_id = funds_int_rec2.FUND_ID
7417: AND USERENV('LANG') IN(language, source_lang);
7418:

Line 7476: ,last_updated_by = NVL (fnd_global.user_id, -1)

7472: ,approved_original_amount = NVL(approved_original_amount, 0) + NVL(budgets_int_rec2.APPROVED_ORIGINAL_AMOUNT,0)
7473: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(budgets_int_rec2.APPROVED_AMOUNT_FC,0)
7474: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(budgets_int_rec2.parent_src_apprvd_amt,0)
7475: ,last_update_date = sysdate
7476: ,last_updated_by = NVL (fnd_global.user_id, -1)
7477: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
7478: ,object_version_number = NVL (object_version_number,0) + 1
7479: WHERE activity_budget_id = l_activity_budget_id;
7480:

Line 7477: ,last_update_login = NVL (fnd_global.conc_login_id, -1)

7473: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(budgets_int_rec2.APPROVED_AMOUNT_FC,0)
7474: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(budgets_int_rec2.parent_src_apprvd_amt,0)
7475: ,last_update_date = sysdate
7476: ,last_updated_by = NVL (fnd_global.user_id, -1)
7477: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
7478: ,object_version_number = NVL (object_version_number,0) + 1
7479: WHERE activity_budget_id = l_activity_budget_id;
7480:
7481: ozf_utility_pvt.write_conc_log('Activity Budget id2 : ' || l_activity_budget_id);

Line 7687: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7683: WHEN MATCHED THEN
7684: UPDATE
7685: SET ovolsum.GROUP_VOLUME = ovolsum.GROUP_VOLUME + nvl(ovolgrpint.GROUP_VOLUME,0),
7686: LAST_UPDATE_DATE = SYSDATE,
7687: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7688: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7689: WHEN NOT MATCHED THEN
7690: INSERT
7691: (

Line 7688: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7684: UPDATE
7685: SET ovolsum.GROUP_VOLUME = ovolsum.GROUP_VOLUME + nvl(ovolgrpint.GROUP_VOLUME,0),
7686: LAST_UPDATE_DATE = SYSDATE,
7687: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7688: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7689: WHEN NOT MATCHED THEN
7690: INSERT
7691: (
7692: ovolsum.volume_summary_id

Line 7707: ,FND_GLOBAL.user_id

7703: VALUES
7704: (
7705: ozf_volume_summary_s.NEXTVAL
7706: ,SYSDATE
7707: ,FND_GLOBAL.user_id
7708: ,SYSDATE
7709: ,FND_GLOBAL.user_id
7710: ,FND_GLOBAL.conc_login_id
7711: ,ovolgrpint.OFFER_ID

Line 7709: ,FND_GLOBAL.user_id

7705: ozf_volume_summary_s.NEXTVAL
7706: ,SYSDATE
7707: ,FND_GLOBAL.user_id
7708: ,SYSDATE
7709: ,FND_GLOBAL.user_id
7710: ,FND_GLOBAL.conc_login_id
7711: ,ovolgrpint.OFFER_ID
7712: ,ovolgrpint.GROUP_NO
7713: ,ovolgrpint.GROUP_VOLUME

Line 7710: ,FND_GLOBAL.conc_login_id

7706: ,SYSDATE
7707: ,FND_GLOBAL.user_id
7708: ,SYSDATE
7709: ,FND_GLOBAL.user_id
7710: ,FND_GLOBAL.conc_login_id
7711: ,ovolgrpint.OFFER_ID
7712: ,ovolgrpint.GROUP_NO
7713: ,ovolgrpint.GROUP_VOLUME
7714: ,ovolgrpint.PBH_LINE_ID

Line 7737: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7733: WHEN MATCHED THEN
7734: UPDATE
7735: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7736: LAST_UPDATE_DATE = SYSDATE,
7737: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7738: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7739: WHEN NOT MATCHED THEN
7740: INSERT
7741: (

Line 7738: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7734: UPDATE
7735: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7736: LAST_UPDATE_DATE = SYSDATE,
7737: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7738: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7739: WHEN NOT MATCHED THEN
7740: INSERT
7741: (
7742: ovolsum.volume_summary_id

Line 7757: ,FND_GLOBAL.user_id

7753: VALUES
7754: (
7755: ozf_volume_summary_s.NEXTVAL
7756: ,SYSDATE
7757: ,FND_GLOBAL.user_id
7758: ,SYSDATE
7759: ,FND_GLOBAL.user_id
7760: ,FND_GLOBAL.conc_login_id
7761: ,ovolindint.OFFER_ID

Line 7759: ,FND_GLOBAL.user_id

7755: ozf_volume_summary_s.NEXTVAL
7756: ,SYSDATE
7757: ,FND_GLOBAL.user_id
7758: ,SYSDATE
7759: ,FND_GLOBAL.user_id
7760: ,FND_GLOBAL.conc_login_id
7761: ,ovolindint.OFFER_ID
7762: ,ovolindint.INDIVIDUAL_TYPE
7763: ,ovolindint.INDIVIDUAL_VOLUME

Line 7760: ,FND_GLOBAL.conc_login_id

7756: ,SYSDATE
7757: ,FND_GLOBAL.user_id
7758: ,SYSDATE
7759: ,FND_GLOBAL.user_id
7760: ,FND_GLOBAL.conc_login_id
7761: ,ovolindint.OFFER_ID
7762: ,ovolindint.INDIVIDUAL_TYPE
7763: ,ovolindint.INDIVIDUAL_VOLUME
7764: ,ovolindint.PBH_LINE_ID

Line 7787: LAST_UPDATED_BY = FND_GLOBAL.user_id,

7783: WHEN MATCHED THEN
7784: UPDATE
7785: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7786: LAST_UPDATE_DATE = SYSDATE,
7787: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7788: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7789: WHEN NOT MATCHED THEN
7790: INSERT
7791: (

Line 7788: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

7784: UPDATE
7785: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7786: LAST_UPDATE_DATE = SYSDATE,
7787: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7788: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7789: WHEN NOT MATCHED THEN
7790: INSERT
7791: (
7792: ovolsum.volume_summary_id

Line 7808: ,FND_GLOBAL.user_id

7804: VALUES
7805: (
7806: ozf_volume_summary_s.NEXTVAL
7807: ,SYSDATE
7808: ,FND_GLOBAL.user_id
7809: ,SYSDATE
7810: ,FND_GLOBAL.user_id
7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID

Line 7810: ,FND_GLOBAL.user_id

7806: ozf_volume_summary_s.NEXTVAL
7807: ,SYSDATE
7808: ,FND_GLOBAL.user_id
7809: ,SYSDATE
7810: ,FND_GLOBAL.user_id
7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID
7813: ,ovolindint.INDIVIDUAL_TYPE
7814: ,ovolindint.INDIVIDUAL_ID

Line 7811: ,FND_GLOBAL.conc_login_id

7807: ,SYSDATE
7808: ,FND_GLOBAL.user_id
7809: ,SYSDATE
7810: ,FND_GLOBAL.user_id
7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID
7813: ,ovolindint.INDIVIDUAL_TYPE
7814: ,ovolindint.INDIVIDUAL_ID
7815: ,ovolindint.INDIVIDUAL_VOLUME

Line 7827: last_updated_by = NVL(fnd_global.user_id, -1),

7823: ozf_utility_pvt.write_conc_log('Updating the status of the batch as CLOSED for Batch Id='||p_batch_id);
7824:
7825: UPDATE ozf_resale_batches_all
7826: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
7827: last_updated_by = NVL(fnd_global.user_id, -1),
7828: last_update_date = SYSDATE
7829: WHERE resale_batch_id = p_batch_id;
7830:
7831: -- Delete the staging tables once the records are updated in the main table.

Line 8073: px_draft_accrual_tbl(line_count).last_updated_by := NVL (fnd_global.user_id, -1) ;

8069: px_draft_accrual_tbl(line_count).draft_run_id := p_draft_run_id;
8070: px_draft_accrual_tbl(line_count).object_type := l_object_type;
8071: px_draft_accrual_tbl(line_count).object_id := l_object_id ;
8072: px_draft_accrual_tbl(line_count).last_update_date := SYSDATE ;
8073: px_draft_accrual_tbl(line_count).last_updated_by := NVL (fnd_global.user_id, -1) ;
8074: px_draft_accrual_tbl(line_count).last_update_login := NVL (fnd_global.conc_login_id, -1) ;
8075: px_draft_accrual_tbl(line_count).creation_date := SYSDATE ;
8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;
8077: px_draft_accrual_tbl(line_count).request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID ;

Line 8074: px_draft_accrual_tbl(line_count).last_update_login := NVL (fnd_global.conc_login_id, -1) ;

8070: px_draft_accrual_tbl(line_count).object_type := l_object_type;
8071: px_draft_accrual_tbl(line_count).object_id := l_object_id ;
8072: px_draft_accrual_tbl(line_count).last_update_date := SYSDATE ;
8073: px_draft_accrual_tbl(line_count).last_updated_by := NVL (fnd_global.user_id, -1) ;
8074: px_draft_accrual_tbl(line_count).last_update_login := NVL (fnd_global.conc_login_id, -1) ;
8075: px_draft_accrual_tbl(line_count).creation_date := SYSDATE ;
8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;
8077: px_draft_accrual_tbl(line_count).request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID ;
8078: px_draft_accrual_tbl(line_count).program_application_id := fnd_global.prog_appl_id ;

Line 8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;

8072: px_draft_accrual_tbl(line_count).last_update_date := SYSDATE ;
8073: px_draft_accrual_tbl(line_count).last_updated_by := NVL (fnd_global.user_id, -1) ;
8074: px_draft_accrual_tbl(line_count).last_update_login := NVL (fnd_global.conc_login_id, -1) ;
8075: px_draft_accrual_tbl(line_count).creation_date := SYSDATE ;
8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;
8077: px_draft_accrual_tbl(line_count).request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID ;
8078: px_draft_accrual_tbl(line_count).program_application_id := fnd_global.prog_appl_id ;
8079: px_draft_accrual_tbl(line_count).program_id := fnd_global.conc_program_id ;
8080: px_draft_accrual_tbl(line_count).program_update_date := SYSDATE ;

Line 8078: px_draft_accrual_tbl(line_count).program_application_id := fnd_global.prog_appl_id ;

8074: px_draft_accrual_tbl(line_count).last_update_login := NVL (fnd_global.conc_login_id, -1) ;
8075: px_draft_accrual_tbl(line_count).creation_date := SYSDATE ;
8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;
8077: px_draft_accrual_tbl(line_count).request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID ;
8078: px_draft_accrual_tbl(line_count).program_application_id := fnd_global.prog_appl_id ;
8079: px_draft_accrual_tbl(line_count).program_id := fnd_global.conc_program_id ;
8080: px_draft_accrual_tbl(line_count).program_update_date := SYSDATE ;
8081: px_draft_accrual_tbl(line_count).utilization_type := p_act_util_rec.utilization_type;
8082: px_draft_accrual_tbl(line_count).plan_type := p_act_budgets_rec.arc_act_budget_used_by;

Line 8079: px_draft_accrual_tbl(line_count).program_id := fnd_global.conc_program_id ;

8075: px_draft_accrual_tbl(line_count).creation_date := SYSDATE ;
8076: px_draft_accrual_tbl(line_count).created_by := NVL (fnd_global.user_id, -1) ;
8077: px_draft_accrual_tbl(line_count).request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID ;
8078: px_draft_accrual_tbl(line_count).program_application_id := fnd_global.prog_appl_id ;
8079: px_draft_accrual_tbl(line_count).program_id := fnd_global.conc_program_id ;
8080: px_draft_accrual_tbl(line_count).program_update_date := SYSDATE ;
8081: px_draft_accrual_tbl(line_count).utilization_type := p_act_util_rec.utilization_type;
8082: px_draft_accrual_tbl(line_count).plan_type := p_act_budgets_rec.arc_act_budget_used_by;
8083: px_draft_accrual_tbl(line_count).plan_id := p_act_budgets_rec.act_budget_used_by_id;