DBA Data[Home] [Help]

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on FND_GLOBAL

Line 691: FND_GLOBAL.apps_initialize

687:
688: END;
689:
690: l_debug_info := 'Before Initializing the Application';
691: FND_GLOBAL.apps_initialize
692: (l_user_id,
693: l_resp_id,
694: l_application_id);
695:

Line 2349: Last_Updated_By = fnd_Global.User_Id

2345:
2346: UPDATE ap_Payment_History_All aph
2347: SET Accounting_Date = l_gl_Date,
2348: Posted_Flag = 'N',
2349: Last_Updated_By = fnd_Global.User_Id
2350: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2351: AND Check_Id = p_Source_Id;
2352:
2353:

Line 2358: Last_Updated_By = fnd_Global.User_Id,

2354: UPDATE ap_Invoice_Payments_All aip
2355: SET Accounting_Date = l_gl_Date,
2356: Posted_Flag = 'N',
2357: Accrual_Posted_Flag = 'N',
2358: Last_Updated_By = fnd_Global.User_Id,
2359: Period_Name = l_Period_Name
2360: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2361: AND Check_Id = p_Source_Id;
2362:

Line 2368: Last_Updated_By = fnd_Global.User_Id,

2364: UPDATE ap_Invoice_distributions_All aid
2365: SET Accounting_Date = l_gl_Date,
2366: Posted_Flag = 'N',
2367: Accrual_Posted_Flag = 'N',
2368: Last_Updated_By = fnd_Global.User_Id,
2369: Period_Name = l_Period_Name
2370: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2371: AND line_type_lookup_code = 'AWT' ;
2372: --end of 8306966

Line 2415: Last_Updated_By = fnd_Global.User_Id,

2411: UPDATE ap_Invoice_Distributions_All Aid
2412: SET Accounting_Date = l_gl_Date,
2413: Posted_Flag = 'N',
2414: Accrual_Posted_Flag = 'N',
2415: Last_Updated_By = fnd_Global.User_Id,
2416: Period_Name =l_Period_Name
2417: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2418: AND Invoice_Id = l_Source_Id;
2419:

Line 2424: Last_Updated_By = fnd_Global.User_Id,

2420: UPDATE ap_self_assessed_tax_dist_all asatd
2421: SET Accounting_Date = l_gl_Date,
2422: Posted_Flag = 'N',
2423: Accrual_Posted_Flag = 'N',
2424: Last_Updated_By = fnd_Global.User_Id,
2425: Period_Name = l_Period_Name
2426: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2427: AND Invoice_Id = l_Source_Id;
2428:

Line 2437: Last_Updated_By = fnd_Global.User_Id

2433:
2434: UPDATE ap_prepay_history_all aph
2435: SET Accounting_Date = l_gl_Date,
2436: Posted_Flag = 'N',
2437: Last_Updated_By = fnd_Global.User_Id
2438: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2439: AND Invoice_Id = l_Source_Id;
2440:
2441: DELETE

Line 5778: , Last_Updated_By = fnd_Global.User_Id

5774: UPDATE ap_Invoice_Distributions_All Aid
5775: SET Accounting_Date = l_gl_Date
5776: , Posted_Flag = 'N'
5777: , Accrual_Posted_Flag = 'N'
5778: , Last_Updated_By = fnd_Global.User_Id
5779: , Period_Name = l_Period_Name
5780: WHERE Accounting_Event_Id = Events_to_Process_tab( i ).Event_Id
5781: AND Invoice_Id = l_Source_Id;
5782:

Line 5787: , Last_Updated_By = fnd_Global.User_Id

5783: UPDATE ap_self_assessed_tax_dist_all asatd
5784: SET Accounting_Date = l_gl_Date
5785: , Posted_Flag = 'N'
5786: , Accrual_Posted_Flag = 'N'
5787: , Last_Updated_By = fnd_Global.User_Id
5788: , Period_Name = l_Period_Name
5789: WHERE Accounting_Event_Id = Events_to_Process_tab( i ).Event_Id
5790: AND Invoice_Id = l_Source_Id;
5791:

Line 5800: , Last_Updated_By = fnd_Global.User_Id

5796:
5797: UPDATE ap_prepay_history_all aph
5798: SET Accounting_Date = l_gl_Date
5799: , Posted_Flag = 'N'
5800: , Last_Updated_By = fnd_Global.User_Id
5801: WHERE Accounting_Event_Id = Events_to_Process_tab( i ).Event_Id
5802: AND Invoice_Id = l_Source_Id;
5803:
5804: DELETE FROM ap_prepay_app_dists

Line 5837: , last_updated_by = fnd_Global.User_Id

5833: WHERE event_id = events_to_process_tab(i).event_id;
5834:
5835: UPDATE gms_award_distributions
5836: SET fc_status = 'N'
5837: , last_updated_by = fnd_Global.User_Id
5838: WHERE invoice_distribution_id IN
5839: (SELECT aid.invoice_distribution_id
5840: FROM ap_invoice_distributions_all aid
5841: WHERE aid.bc_event_id = events_to_process_tab(i).event_id

Line 5849: , last_updated_by = fnd_Global.User_Id

5845: UPDATE ap_invoice_distributions_all aid
5846: SET encumbered_flag = 'N'
5847: , bc_event_id = NULL
5848: , match_status_flag = 'T'
5849: , last_updated_by = fnd_Global.User_Id
5850: WHERE aid.bc_event_id = events_to_process_tab(i).event_id
5851: AND aid.invoice_id = p_source_id;
5852:
5853: UPDATE ap_self_assessed_tax_dist_all aid

Line 5857: , last_updated_by = fnd_Global.User_Id

5853: UPDATE ap_self_assessed_tax_dist_all aid
5854: SET encumbered_flag = 'N'
5855: , bc_event_id = NULL
5856: , match_status_flag = 'T'
5857: , last_updated_by = fnd_Global.User_Id
5858: WHERE aid.bc_event_id = events_to_process_tab(i).event_id
5859: AND aid.invoice_id = p_source_id;
5860:
5861: UPDATE ap_prepay_history_all apph

Line 5863: , last_updated_by = fnd_Global.User_Id

5859: AND aid.invoice_id = p_source_id;
5860:
5861: UPDATE ap_prepay_history_all apph
5862: SET bc_event_id = NULL
5863: , last_updated_by = fnd_Global.User_Id
5864: WHERE apph.bc_event_id = events_to_process_tab(i).event_id
5865: AND apph.invoice_id = p_source_id;
5866:
5867: UPDATE ap_prepay_app_dists

Line 5869: , last_updated_by = fnd_Global.User_Id

5865: AND apph.invoice_id = p_source_id;
5866:
5867: UPDATE ap_prepay_app_dists
5868: SET bc_event_id = NULL
5869: , last_updated_by = fnd_Global.User_Id
5870: WHERE bc_event_id = events_to_process_tab(i).event_id
5871: AND prepay_history_id IN
5872: (SELECT apph.prepay_history_id
5873: FROM ap_prepay_history_all apph

Line 5879: , last_updated_by = fnd_Global.User_Id

5875:
5876: --bug12833171
5877: UPDATE ap_invoices_all
5878: SET cancelled_date = NULL
5879: , last_updated_by = fnd_Global.User_Id
5880: WHERE invoice_id = p_source_id
5881: AND cancelled_date IS NOT NULL
5882: AND events_to_process_tab(i).event_type_code IN
5883: ('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',

Line 6416: vNewLine := vNewLine||fnd_global.local_chr(10);

6412: vInHandle_read := utl_file.fopen(v_dir_name,'gdftemp.html', 'r',32767);
6413: BEGIN
6414: LOOP
6415: utl_file.get_line(vInHandle_read,vNewLine);
6416: vNewLine := vNewLine||fnd_global.local_chr(10);
6417: v_attachment := v_attachment||vNewLine;
6418: END LOOP;
6419: EXCEPTION
6420: WHEN NO_DATA_FOUND THEN