DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_REP_UTILITY dependencies on FND_GLOBAL

Line 97: fnd_global.user_id ,

93: fnd_profile.value('PROG_APPL_ID') ,
94: fnd_profile.value('CONC_PROGRAM_ID') ,
95: trunc(sysdate) ,
96: fnd_profile.value('CONC_LOGIN_ID') ,
97: fnd_global.user_id ,
98: sysdate ,
99: fnd_global.user_id ,
100: sysdate ,
101: fnd_global.login_id ,

Line 99: fnd_global.user_id ,

95: trunc(sysdate) ,
96: fnd_profile.value('CONC_LOGIN_ID') ,
97: fnd_global.user_id ,
98: sysdate ,
99: fnd_global.user_id ,
100: sysdate ,
101: fnd_global.login_id ,
102: pn_mapping_vat_rep_entity_id
103: ) returning reporting_status_id into xn_reporting_status_id ;

Line 101: fnd_global.login_id ,

97: fnd_global.user_id ,
98: sysdate ,
99: fnd_global.user_id ,
100: sysdate ,
101: fnd_global.login_id ,
102: pn_mapping_vat_rep_entity_id
103: ) returning reporting_status_id into xn_reporting_status_id ;
104:
105: end insert_row;

Line 310: last_updated_by = fnd_global.user_id,

306: allocation_process_date = null,
307: final_reporting_status_flag = null,
308: final_reporting_process_id = null,
309: final_reporting_process_date = null,
310: last_updated_by = fnd_global.user_id,
311: last_update_date = sysdate,
312: last_update_login = fnd_global.login_id
313: where
314: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 312: last_update_login = fnd_global.login_id

308: final_reporting_process_id = null,
309: final_reporting_process_date = null,
310: last_updated_by = fnd_global.user_id,
311: last_update_date = sysdate,
312: last_update_login = fnd_global.login_id
313: where
314: vat_reporting_entity_id = pn_vat_reporting_entity_id
315: and tax_calendar_period = pv_tax_calendar_period
316: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 329: last_updated_by = fnd_global.user_id,

325: allocation_process_date = null,
326: final_reporting_status_flag = null,
327: final_reporting_process_id = null,
328: final_reporting_process_date = null,
329: last_updated_by = fnd_global.user_id,
330: last_update_date = sysdate,
331: last_update_login = fnd_global.login_id
332: where
333: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 331: last_update_login = fnd_global.login_id

327: final_reporting_process_id = null,
328: final_reporting_process_date = null,
329: last_updated_by = fnd_global.user_id,
330: last_update_date = sysdate,
331: last_update_login = fnd_global.login_id
332: where
333: vat_reporting_entity_id = pn_vat_reporting_entity_id
334: and tax_calendar_period = pv_tax_calendar_period
335: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 345: last_updated_by = fnd_global.user_id,

341: Set
342: final_reporting_status_flag = null,
343: final_reporting_process_id = null,
344: final_reporting_process_date = null,
345: last_updated_by = fnd_global.user_id,
346: last_update_date = sysdate,
347: last_update_login = fnd_global.login_id
348: where
349: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 347: last_update_login = fnd_global.login_id

343: final_reporting_process_id = null,
344: final_reporting_process_date = null,
345: last_updated_by = fnd_global.user_id,
346: last_update_date = sysdate,
347: last_update_login = fnd_global.login_id
348: where
349: vat_reporting_entity_id = pn_vat_reporting_entity_id
350: and tax_calendar_period = pv_tax_calendar_period
351: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 815: last_updated_by = fnd_global.user_id,

811: Set
812: selection_status_flag = pv_process_flag ,
813: Selection_process_id = pn_process_id ,
814: selection_process_date = sysdate ,
815: last_updated_by = fnd_global.user_id,
816: last_update_date = sysdate ,
817: last_update_login = fnd_global.login_id
818: where
819: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 817: last_update_login = fnd_global.login_id

813: Selection_process_id = pn_process_id ,
814: selection_process_date = sysdate ,
815: last_updated_by = fnd_global.user_id,
816: last_update_date = sysdate ,
817: last_update_login = fnd_global.login_id
818: where
819: vat_reporting_entity_id = pn_vat_reporting_entity_id
820: and tax_calendar_period = pv_tax_calendar_period
821: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 831: last_updated_by = fnd_global.user_id ,

827: Set
828: allocation_status_flag = pv_process_flag ,
829: allocation_process_id = pn_process_id ,
830: allocation_process_date = sysdate ,
831: last_updated_by = fnd_global.user_id ,
832: last_update_date = sysdate ,
833: last_update_login = fnd_global.login_id
834: where
835: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 833: last_update_login = fnd_global.login_id

829: allocation_process_id = pn_process_id ,
830: allocation_process_date = sysdate ,
831: last_updated_by = fnd_global.user_id ,
832: last_update_date = sysdate ,
833: last_update_login = fnd_global.login_id
834: where
835: vat_reporting_entity_id = pn_vat_reporting_entity_id
836: and tax_calendar_period = pv_tax_calendar_period
837: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 850: last_updated_by = fnd_global.user_id,

846: final_reporting_process_date = sysdate ,
847: allocation_status_flag =
848: decode(pv_enable_allocations_flag, null, allocation_status_flag, pv_enable_allocations_flag),
849: /* if allocation is not applicable , it should be captured here */
850: last_updated_by = fnd_global.user_id,
851: last_update_date = sysdate ,
852: last_update_login = fnd_global.login_id
853: where
854: vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 852: last_update_login = fnd_global.login_id

848: decode(pv_enable_allocations_flag, null, allocation_status_flag, pv_enable_allocations_flag),
849: /* if allocation is not applicable , it should be captured here */
850: last_updated_by = fnd_global.user_id,
851: last_update_date = sysdate ,
852: last_update_login = fnd_global.login_id
853: where
854: vat_reporting_entity_id = pn_vat_reporting_entity_id
855: and tax_calendar_period = pv_tax_calendar_period
856: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );

Line 1190: lr_record.created_by := fnd_global.user_id;

1186: lr_record.ledger_id := pn_ledger_id;
1187: lr_record.entity_level_code := pv_entity_level_code;
1188: lr_record.balancing_segment_value := pv_balancing_segment_value;
1189: lr_record.mapping_vat_rep_entity_id := pn_vat_reporting_entity_id;
1190: lr_record.created_by := fnd_global.user_id;
1191: lr_record.creation_date := sysdate;
1192: lr_record.last_updated_by := fnd_global.user_id;
1193: lr_record.last_update_date := sysdate;
1194: lr_record.last_update_login := fnd_global.login_id;

Line 1192: lr_record.last_updated_by := fnd_global.user_id;

1188: lr_record.balancing_segment_value := pv_balancing_segment_value;
1189: lr_record.mapping_vat_rep_entity_id := pn_vat_reporting_entity_id;
1190: lr_record.created_by := fnd_global.user_id;
1191: lr_record.creation_date := sysdate;
1192: lr_record.last_updated_by := fnd_global.user_id;
1193: lr_record.last_update_date := sysdate;
1194: lr_record.last_update_login := fnd_global.login_id;
1195:
1196: jg_zz_vat_rep_entities_pkg.insert_row

Line 1194: lr_record.last_update_login := fnd_global.login_id;

1190: lr_record.created_by := fnd_global.user_id;
1191: lr_record.creation_date := sysdate;
1192: lr_record.last_updated_by := fnd_global.user_id;
1193: lr_record.last_update_date := sysdate;
1194: lr_record.last_update_login := fnd_global.login_id;
1195:
1196: jg_zz_vat_rep_entities_pkg.insert_row
1197: (
1198: x_record => lr_record,