DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on FND_GLOBAL

Line 157: TmpProgId NUMBER:= fnd_global.conc_program_id;

153: TmpSiteUSeId2 NUMBER;
154: TmpInvoiceNum NUMBER;
155:
156:
157: TmpProgId NUMBER:= fnd_global.conc_program_id;
158: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
159: l_program_update_date DATE := sysdate;
160: l_last_update_date DATE := sysdate;
161: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 158: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;

154: TmpInvoiceNum NUMBER;
155:
156:
157: TmpProgId NUMBER:= fnd_global.conc_program_id;
158: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
159: l_program_update_date DATE := sysdate;
160: l_last_update_date DATE := sysdate;
161: l_last_updated_by NUMBER:= fnd_global.user_id;
162: l_last_update_login NUMBER:= fnd_global.login_id;

Line 161: l_last_updated_by NUMBER:= fnd_global.user_id;

157: TmpProgId NUMBER:= fnd_global.conc_program_id;
158: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
159: l_program_update_date DATE := sysdate;
160: l_last_update_date DATE := sysdate;
161: l_last_updated_by NUMBER:= fnd_global.user_id;
162: l_last_update_login NUMBER:= fnd_global.login_id;
163: TmpUserId NUMBER:= fnd_global.user_id;
164:
165: --Tmp_Output_vat_tax_id NUMBER;

Line 162: l_last_update_login NUMBER:= fnd_global.login_id;

158: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
159: l_program_update_date DATE := sysdate;
160: l_last_update_date DATE := sysdate;
161: l_last_updated_by NUMBER:= fnd_global.user_id;
162: l_last_update_login NUMBER:= fnd_global.login_id;
163: TmpUserId NUMBER:= fnd_global.user_id;
164:
165: --Tmp_Output_vat_tax_id NUMBER;
166: Tmp_output_tax_code VARCHAR2(30);

Line 163: TmpUserId NUMBER:= fnd_global.user_id;

159: l_program_update_date DATE := sysdate;
160: l_last_update_date DATE := sysdate;
161: l_last_updated_by NUMBER:= fnd_global.user_id;
162: l_last_update_login NUMBER:= fnd_global.login_id;
163: TmpUserId NUMBER:= fnd_global.user_id;
164:
165: --Tmp_Output_vat_tax_id NUMBER;
166: Tmp_output_tax_code VARCHAR2(30);
167: Tmp_Output_tax_exempt_flag VARCHAR2(2);

Line 754: LastUpdatedBy NUMBER:= fnd_global.user_id;

750: p_TotRetenion IN NUMBER,
751: p_client_extn_flag IN VARCHAR2) IS
752: LastLineNum NUMBER:=0;
753:
754: LastUpdatedBy NUMBER:= fnd_global.user_id;
755: l_created_by NUMBER:= fnd_global.user_id;
756: l_program_id NUMBER:= fnd_global.conc_program_id;
757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;

Line 755: l_created_by NUMBER:= fnd_global.user_id;

751: p_client_extn_flag IN VARCHAR2) IS
752: LastLineNum NUMBER:=0;
753:
754: LastUpdatedBy NUMBER:= fnd_global.user_id;
755: l_created_by NUMBER:= fnd_global.user_id;
756: l_program_id NUMBER:= fnd_global.conc_program_id;
757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;
759: l_last_update_date DATE := sysdate;

Line 756: l_program_id NUMBER:= fnd_global.conc_program_id;

752: LastLineNum NUMBER:=0;
753:
754: LastUpdatedBy NUMBER:= fnd_global.user_id;
755: l_created_by NUMBER:= fnd_global.user_id;
756: l_program_id NUMBER:= fnd_global.conc_program_id;
757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;
759: l_last_update_date DATE := sysdate;
760: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

753:
754: LastUpdatedBy NUMBER:= fnd_global.user_id;
755: l_created_by NUMBER:= fnd_global.user_id;
756: l_program_id NUMBER:= fnd_global.conc_program_id;
757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;
759: l_last_update_date DATE := sysdate;
760: l_last_updated_by NUMBER:= fnd_global.user_id;
761: l_last_update_login NUMBER:= fnd_global.login_id;

Line 760: l_last_updated_by NUMBER:= fnd_global.user_id;

756: l_program_id NUMBER:= fnd_global.conc_program_id;
757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;
759: l_last_update_date DATE := sysdate;
760: l_last_updated_by NUMBER:= fnd_global.user_id;
761: l_last_update_login NUMBER:= fnd_global.login_id;
762:
763: RetnLineText VARCHAR2(500);
764: TempText VARCHAR2(80);

Line 761: l_last_update_login NUMBER:= fnd_global.login_id;

757: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
758: l_program_update_date DATE := sysdate;
759: l_last_update_date DATE := sysdate;
760: l_last_updated_by NUMBER:= fnd_global.user_id;
761: l_last_update_login NUMBER:= fnd_global.login_id;
762:
763: RetnLineText VARCHAR2(500);
764: TempText VARCHAR2(80);
765: l_RetnInvLineFmt pa_retn_billing_pkg.TabRetnBillingInvFmt;

Line 1147: LastUpdatedBy NUMBER:= fnd_global.user_id;

1143: AND nvl(task_id,-99) = NVL(p_task_id,-99);
1144:
1145: ProjRetnRec cur_proj_retn%ROWTYPE;
1146:
1147: LastUpdatedBy NUMBER:= fnd_global.user_id;
1148: l_created_by NUMBER:= fnd_global.user_id;
1149: l_program_id NUMBER:= fnd_global.conc_program_id;
1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;

Line 1148: l_created_by NUMBER:= fnd_global.user_id;

1144:
1145: ProjRetnRec cur_proj_retn%ROWTYPE;
1146:
1147: LastUpdatedBy NUMBER:= fnd_global.user_id;
1148: l_created_by NUMBER:= fnd_global.user_id;
1149: l_program_id NUMBER:= fnd_global.conc_program_id;
1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;
1152: l_last_update_date DATE := sysdate;

Line 1149: l_program_id NUMBER:= fnd_global.conc_program_id;

1145: ProjRetnRec cur_proj_retn%ROWTYPE;
1146:
1147: LastUpdatedBy NUMBER:= fnd_global.user_id;
1148: l_created_by NUMBER:= fnd_global.user_id;
1149: l_program_id NUMBER:= fnd_global.conc_program_id;
1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;
1152: l_last_update_date DATE := sysdate;
1153: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

1146:
1147: LastUpdatedBy NUMBER:= fnd_global.user_id;
1148: l_created_by NUMBER:= fnd_global.user_id;
1149: l_program_id NUMBER:= fnd_global.conc_program_id;
1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;
1152: l_last_update_date DATE := sysdate;
1153: l_last_updated_by NUMBER:= fnd_global.user_id;
1154: l_last_update_login NUMBER:= fnd_global.login_id;

Line 1153: l_last_updated_by NUMBER:= fnd_global.user_id;

1149: l_program_id NUMBER:= fnd_global.conc_program_id;
1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;
1152: l_last_update_date DATE := sysdate;
1153: l_last_updated_by NUMBER:= fnd_global.user_id;
1154: l_last_update_login NUMBER:= fnd_global.login_id;
1155: l_detail_id NUMBER;
1156:
1157:

Line 1154: l_last_update_login NUMBER:= fnd_global.login_id;

1150: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
1151: l_program_update_date DATE := sysdate;
1152: l_last_update_date DATE := sysdate;
1153: l_last_updated_by NUMBER:= fnd_global.user_id;
1154: l_last_update_login NUMBER:= fnd_global.login_id;
1155: l_detail_id NUMBER;
1156:
1157:
1158: BEGIN

Line 1974: TmpUserId NUMBER:= fnd_global.user_id;

1970: AND NVL(GENERATION_ERROR_FLAG,'N') ='N'
1971: AND NVL(retention_invoice_flag,'N') = 'Y'
1972: GROUP BY project_id;
1973:
1974: TmpUserId NUMBER:= fnd_global.user_id;
1975:
1976: BEGIN
1977: IF g1_debug_mode = 'Y' THEN
1978: pa_retention_util.write_log('Entering Update_Inv_Trans_Attributes');

Line 2026: TmpProgId NUMBER:= fnd_global.conc_program_id;

2022: ORDER BY pr.segment1;
2023:
2024: RecSelectProjects cur_select_projects%ROWTYPE;
2025:
2026: TmpProgId NUMBER:= fnd_global.conc_program_id;
2027: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
2028: l_program_update_date DATE := sysdate;
2029: l_last_update_date DATE := sysdate;
2030: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 2027: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;

2023:
2024: RecSelectProjects cur_select_projects%ROWTYPE;
2025:
2026: TmpProgId NUMBER:= fnd_global.conc_program_id;
2027: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
2028: l_program_update_date DATE := sysdate;
2029: l_last_update_date DATE := sysdate;
2030: l_last_updated_by NUMBER:= fnd_global.user_id;
2031: l_last_update_login NUMBER:= fnd_global.login_id;

Line 2030: l_last_updated_by NUMBER:= fnd_global.user_id;

2026: TmpProgId NUMBER:= fnd_global.conc_program_id;
2027: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
2028: l_program_update_date DATE := sysdate;
2029: l_last_update_date DATE := sysdate;
2030: l_last_updated_by NUMBER:= fnd_global.user_id;
2031: l_last_update_login NUMBER:= fnd_global.login_id;
2032: TmpUserId NUMBER:= fnd_global.user_id;
2033: TmpInvoiceNum NUMBER:=NULL;
2034: TmpWarningMsg VARCHAR2(80);

Line 2031: l_last_update_login NUMBER:= fnd_global.login_id;

2027: TmpProgApplId NUMBER:= fnd_global.prog_appl_id;
2028: l_program_update_date DATE := sysdate;
2029: l_last_update_date DATE := sysdate;
2030: l_last_updated_by NUMBER:= fnd_global.user_id;
2031: l_last_update_login NUMBER:= fnd_global.login_id;
2032: TmpUserId NUMBER:= fnd_global.user_id;
2033: TmpInvoiceNum NUMBER:=NULL;
2034: TmpWarningMsg VARCHAR2(80);
2035: TmpWarningCode VARCHAR2(30):= 'NO_RETN_BILLING_INVOICES';

Line 2032: TmpUserId NUMBER:= fnd_global.user_id;

2028: l_program_update_date DATE := sysdate;
2029: l_last_update_date DATE := sysdate;
2030: l_last_updated_by NUMBER:= fnd_global.user_id;
2031: l_last_update_login NUMBER:= fnd_global.login_id;
2032: TmpUserId NUMBER:= fnd_global.user_id;
2033: TmpInvoiceNum NUMBER:=NULL;
2034: TmpWarningMsg VARCHAR2(80);
2035: TmpWarningCode VARCHAR2(30):= 'NO_RETN_BILLING_INVOICES';
2036: