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.AP_SLA_PROCESSING_PKG dependencies on FND_GLOBAL

Line 163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

159: FORALL i IN 1 .. p_event_ids.count
160: UPDATE ap_payment_history_All APH
161: SET POSTED_FLAG = 'S'
162: -- bug 10101613
163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
164: ,LAST_UPDATE_DATE = SYSDATE
165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
166: WHERE APH.accounting_event_id = p_event_ids(i);
167:

Line 165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

161: SET POSTED_FLAG = 'S'
162: -- bug 10101613
163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
164: ,LAST_UPDATE_DATE = SYSDATE
165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
166: WHERE APH.accounting_event_id = p_event_ids(i);
167:
168: ---------------------------------------------------------------------
169: l_debug_info := 'Mark the payments posted_flag';

Line 182: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

178: FORALL i IN 1 .. p_event_ids.count
179: UPDATE ap_invoice_payments_all AIP
180: SET AIP.posted_flag = 'S'
181: -- bug 10101613
182: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
183: ,LAST_UPDATE_DATE = SYSDATE
184: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
185: WHERE AIP.accounting_event_id = p_event_ids(i);
186:

Line 184: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

180: SET AIP.posted_flag = 'S'
181: -- bug 10101613
182: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
183: ,LAST_UPDATE_DATE = SYSDATE
184: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
185: WHERE AIP.accounting_event_id = p_event_ids(i);
186:
187: END IF;
188:

Line 206: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

202: FORALL i IN 1 .. p_event_ids.count
203: UPDATE ap_invoice_distributions_all AID
204: SET AID.posted_flag = 'S'
205: -- bug 10101613
206: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
207: ,LAST_UPDATE_DATE = SYSDATE
208: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
209: WHERE AID.accounting_event_id = p_event_ids(i);
210:

Line 208: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

204: SET AID.posted_flag = 'S'
205: -- bug 10101613
206: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
207: ,LAST_UPDATE_DATE = SYSDATE
208: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
209: WHERE AID.accounting_event_id = p_event_ids(i);
210:
211: -- bug fix 6975868
212: FORALL i IN 1 .. p_event_ids.count

Line 216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

212: FORALL i IN 1 .. p_event_ids.count
213: UPDATE ap_self_assessed_tax_dist_all STID
214: SET STID.posted_flag = 'S'
215: -- bug 10101613
216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
217: ,LAST_UPDATE_DATE = SYSDATE
218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
219: WHERE STID.accounting_event_id = p_event_ids(i);
220:

Line 218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

214: SET STID.posted_flag = 'S'
215: -- bug 10101613
216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
217: ,LAST_UPDATE_DATE = SYSDATE
218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
219: WHERE STID.accounting_event_id = p_event_ids(i);
220:
221: ---------------------------------------------------------------------
222: l_debug_info := 'Mark prepayment history posted flag';

Line 230: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

226: FORALL i IN 1 .. p_event_ids.count
227: UPDATE ap_prepay_history_all APPH
228: SET POSTED_FLAG = 'S'
229: -- bug 10101613
230: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
231: ,LAST_UPDATE_DATE = SYSDATE
232: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
233: WHERE APPH.accounting_event_id = p_event_ids(i);
234:

Line 232: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

228: SET POSTED_FLAG = 'S'
229: -- bug 10101613
230: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
231: ,LAST_UPDATE_DATE = SYSDATE
232: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
233: WHERE APPH.accounting_event_id = p_event_ids(i);
234:
235: END IF;
236:

Line 783: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

779: FORALL num in 1 .. l_accrual_event_ids.COUNT
780: UPDATE AP_Invoice_Payments_all
781: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
782: -- bug 10101613
783: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
784: ,LAST_UPDATE_DATE = SYSDATE
785: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
786: WHERE Accounting_Event_ID = l_accrual_event_ids(num);
787:

Line 785: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

781: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
782: -- bug 10101613
783: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
784: ,LAST_UPDATE_DATE = SYSDATE
785: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
786: WHERE Accounting_Event_ID = l_accrual_event_ids(num);
787:
788: FORALL num in 1 .. l_accrual_event_ids.COUNT
789: UPDATE AP_Invoice_Distributions_all

Line 792: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

788: FORALL num in 1 .. l_accrual_event_ids.COUNT
789: UPDATE AP_Invoice_Distributions_all
790: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
791: -- bug 10101613
792: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
793: ,LAST_UPDATE_DATE = SYSDATE
794: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
795: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
796: RETURNING invoice_distribution_id,detail_tax_dist_id

Line 794: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

790: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
791: -- bug 10101613
792: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
793: ,LAST_UPDATE_DATE = SYSDATE
794: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
795: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
796: RETURNING invoice_distribution_id,detail_tax_dist_id
797: BULK COLLECT INTO l_dbi_key_value_list1,
798: l_tax_dist_id_list1;

Line 817: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

813: FORALL num in 1 .. l_accrual_event_ids.COUNT
814: UPDATE ap_self_assessed_tax_dist_all
815: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
816: -- bug 10101613
817: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
818: ,LAST_UPDATE_DATE = SYSDATE
819: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
820: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
821: RETURNING detail_tax_dist_id

Line 819: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

815: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
816: -- bug 10101613
817: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
818: ,LAST_UPDATE_DATE = SYSDATE
819: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
820: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
821: RETURNING detail_tax_dist_id
822: BULK COLLECT INTO l_tax_dist_id_list1;
823:

Line 873: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

869: FORALL num in 1 .. l_cash_event_ids.COUNT
870: UPDATE AP_Invoice_Payments_all
871: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'N', Cash_Posted_Flag = 'Y'
872: -- bug 10101613
873: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
874: ,LAST_UPDATE_DATE = SYSDATE
875: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
876: WHERE Accounting_Event_ID = l_cash_event_ids(num);
877:

Line 875: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

871: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'N', Cash_Posted_Flag = 'Y'
872: -- bug 10101613
873: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
874: ,LAST_UPDATE_DATE = SYSDATE
875: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
876: WHERE Accounting_Event_ID = l_cash_event_ids(num);
877:
878: -- update for prepay event
879:

Line 893: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

889: SET AID.Posted_Flag = 'Y',
890: AID.Accrual_Posted_Flag = 'N',
891: AID.Cash_Posted_Flag = 'Y'
892: -- bug 10101613
893: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
894: ,LAST_UPDATE_DATE = SYSDATE
895: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
896: WHERE AID.Accounting_Event_ID = l_prepay_event_list(num)
897: RETURNING invoice_distribution_id,detail_tax_dist_id

Line 895: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

891: AID.Cash_Posted_Flag = 'Y'
892: -- bug 10101613
893: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
894: ,LAST_UPDATE_DATE = SYSDATE
895: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
896: WHERE AID.Accounting_Event_ID = l_prepay_event_list(num)
897: RETURNING invoice_distribution_id,detail_tax_dist_id
898: BULK COLLECT INTO l_dbi_key_value_list1,
899: l_tax_dist_id_list1;

Line 982: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

978: SET STID.Posted_Flag = 'Y',
979: STID.Accrual_Posted_Flag = 'N',
980: STID.Cash_Posted_Flag = 'Y'
981: -- bug 10101613
982: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
983: ,LAST_UPDATE_DATE = SYSDATE
984: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
985: WHERE STID.Accounting_Event_ID = l_prepay_event_list(num)
986: RETURNING detail_tax_dist_id

Line 984: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

980: STID.Cash_Posted_Flag = 'Y'
981: -- bug 10101613
982: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
983: ,LAST_UPDATE_DATE = SYSDATE
984: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
985: WHERE STID.Accounting_Event_ID = l_prepay_event_list(num)
986: RETURNING detail_tax_dist_id
987: BULK COLLECT INTO l_tax_dist_id_list1;
988:

Line 1036: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1032: FORALL num in 1 .. l_event_list.COUNT
1033: UPDATE ap_payment_history_all APH
1034: SET APH.posted_flag = 'Y'
1035: -- bug 10101613
1036: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1037: ,LAST_UPDATE_DATE = SYSDATE
1038: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1039: WHERE APH.accounting_event_id = l_event_list(num);
1040:

Line 1038: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1034: SET APH.posted_flag = 'Y'
1035: -- bug 10101613
1036: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1037: ,LAST_UPDATE_DATE = SYSDATE
1038: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1039: WHERE APH.accounting_event_id = l_event_list(num);
1040:
1041: -----------------------------------------------------------------------
1042: l_debug_info :=

Line 1051: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1047: FORALL num in 1 .. l_event_list.COUNT
1048: UPDATE ap_prepay_history_all APPH
1049: SET APPH.posted_flag = 'Y'
1050: -- bug 10101613
1051: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1052: ,LAST_UPDATE_DATE = SYSDATE
1053: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1054: WHERE APPH.accounting_event_id = l_event_list(num);
1055:

Line 1053: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1049: SET APPH.posted_flag = 'Y'
1050: -- bug 10101613
1051: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1052: ,LAST_UPDATE_DATE = SYSDATE
1053: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1054: WHERE APPH.accounting_event_id = l_event_list(num);
1055:
1056: -----------------------------------------------------------------------
1057: l_debug_info :=

Line 1066: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1062: FORALL num in 1 .. l_check_id_list.COUNT
1063: UPDATE AP_Checks_All
1064: SET status_lookup_code = l_check_status_list(num)
1065: -- bug 10101613
1066: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1067: ,LAST_UPDATE_DATE = SYSDATE
1068: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1069: WHERE check_id = l_check_id_list(num)
1070: --Bug 8973135 Start

Line 1068: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1064: SET status_lookup_code = l_check_status_list(num)
1065: -- bug 10101613
1066: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1067: ,LAST_UPDATE_DATE = SYSDATE
1068: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1069: WHERE check_id = l_check_id_list(num)
1070: --Bug 8973135 Start
1071: AND not exists (SELECT 1 FROM ap_payment_history_all aph,
1072: ap_system_parameters_all asp

Line 1098: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1094: AID.Invoice_Distribution_ID,
1095: AID.Amount,
1096: l_curr_calling_sequence)
1097: -- bug 10101613
1098: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1099: ,LAST_UPDATE_DATE = SYSDATE
1100: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1101: WHERE AID.Invoice_ID = l_invID_list(num)
1102: AND AID.Prepay_Distribution_ID IS NULL

Line 1100: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1096: l_curr_calling_sequence)
1097: -- bug 10101613
1098: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1099: ,LAST_UPDATE_DATE = SYSDATE
1100: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1101: WHERE AID.Invoice_ID = l_invID_list(num)
1102: AND AID.Prepay_Distribution_ID IS NULL
1103: AND AID.prepay_tax_parent_id IS NULL
1104: AND nvl(AID.cancellation_flag,'N') <> 'Y'

Line 1163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1159: STID.Invoice_Distribution_ID,
1160: STID.Amount,
1161: l_curr_calling_sequence)
1162: -- bug 10101613
1163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1164: ,LAST_UPDATE_DATE = SYSDATE
1165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1166: WHERE STID.Invoice_ID = l_invID_list(num)
1167: AND STID.Prepay_Distribution_ID IS NULL

Line 1165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1161: l_curr_calling_sequence)
1162: -- bug 10101613
1163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1164: ,LAST_UPDATE_DATE = SYSDATE
1165: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1166: WHERE STID.Invoice_ID = l_invID_list(num)
1167: AND STID.Prepay_Distribution_ID IS NULL
1168: AND nvl(STID.cancellation_flag,'N') <> 'Y'
1169: RETURNING detail_tax_dist_id

Line 1216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1212: -1,
1213: AID.invoice_distribution_id,
1214: 'SQL'),0)
1215: -- bug 10101613
1216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1217: ,LAST_UPDATE_DATE = SYSDATE
1218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1219: WHERE AID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1220: FROM Ap_Invoice_Payments_All AIP,

Line 1218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1214: 'SQL'),0)
1215: -- bug 10101613
1216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1217: ,LAST_UPDATE_DATE = SYSDATE
1218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1219: WHERE AID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1220: FROM Ap_Invoice_Payments_All AIP,
1221: Ap_Payment_History_All APH --bug 9151717
1222: WHERE AIP.check_id = APH.check_id

Line 1287: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1283: STID.Invoice_Distribution_ID,
1284: STID.Amount,
1285: l_curr_calling_sequence)
1286: -- bug 10101613
1287: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1288: ,LAST_UPDATE_DATE = SYSDATE
1289: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1290: WHERE STID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1291: FROM Ap_Invoice_Payments_All AIP,

Line 1289: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1285: l_curr_calling_sequence)
1286: -- bug 10101613
1287: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1288: ,LAST_UPDATE_DATE = SYSDATE
1289: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1290: WHERE STID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1291: FROM Ap_Invoice_Payments_All AIP,
1292: Ap_Payment_History_All APH --bug 9151717
1293: WHERE AIP.check_id = APH.check_id

Line 1340: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1336: AID.Invoice_Distribution_ID,
1337: AID.Amount,
1338: l_curr_calling_sequence)
1339: -- bug 10101613
1340: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1341: ,LAST_UPDATE_DATE = SYSDATE
1342: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1343: WHERE AID.Invoice_ID IN (SELECT AIP.invoice_id
1344: FROM Ap_Invoice_Payments_All AIP

Line 1342: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1338: l_curr_calling_sequence)
1339: -- bug 10101613
1340: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1341: ,LAST_UPDATE_DATE = SYSDATE
1342: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1343: WHERE AID.Invoice_ID IN (SELECT AIP.invoice_id
1344: FROM Ap_Invoice_Payments_All AIP
1345: WHERE AIP.Accounting_Event_ID
1346: = l_other_event_list(num))

Line 1409: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1405: STID.Invoice_Distribution_ID,
1406: STID.Amount,
1407: l_curr_calling_sequence)
1408: -- bug 10101613
1409: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1410: ,LAST_UPDATE_DATE = SYSDATE
1411: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1412: WHERE STID.Invoice_ID IN (SELECT AIP.invoice_id
1413: FROM Ap_Invoice_Payments_All AIP

Line 1411: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1407: l_curr_calling_sequence)
1408: -- bug 10101613
1409: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1410: ,LAST_UPDATE_DATE = SYSDATE
1411: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1412: WHERE STID.Invoice_ID IN (SELECT AIP.invoice_id
1413: FROM Ap_Invoice_Payments_All AIP
1414: WHERE AIP.Accounting_Event_ID
1415: = l_other_event_list(num))

Line 1453: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1449: l_cash_inv_event_list(num),
1450: AID.Invoice_Distribution_ID,
1451: AID.Amount,
1452: l_curr_calling_sequence)
1453: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1454: ,LAST_UPDATE_DATE = SYSDATE
1455: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1456: WHERE AID.accounting_event_id = l_cash_inv_event_list(num)
1457: AND AID.Prepay_Distribution_ID IS NULL

Line 1455: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1451: AID.Amount,
1452: l_curr_calling_sequence)
1453: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1454: ,LAST_UPDATE_DATE = SYSDATE
1455: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1456: WHERE AID.accounting_event_id = l_cash_inv_event_list(num)
1457: AND AID.Prepay_Distribution_ID IS NULL
1458: AND AID.prepay_tax_parent_id IS NULL
1459: RETURNING invoice_distribution_id,detail_tax_dist_id

Line 1516: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1512: l_cash_inv_event_list(num),
1513: STID.Invoice_Distribution_ID,
1514: STID.Amount,
1515: l_curr_calling_sequence)
1516: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1517: ,LAST_UPDATE_DATE = SYSDATE
1518: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1519: WHERE STID.accounting_event_id = l_cash_inv_event_list(num)
1520: AND STID.Prepay_Distribution_ID IS NULL

Line 1518: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1514: STID.Amount,
1515: l_curr_calling_sequence)
1516: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1517: ,LAST_UPDATE_DATE = SYSDATE
1518: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1519: WHERE STID.accounting_event_id = l_cash_inv_event_list(num)
1520: AND STID.Prepay_Distribution_ID IS NULL
1521: RETURNING detail_tax_dist_id
1522: BULK COLLECT INTO l_tax_dist_id_list1;

Line 1660: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1656: FORALL i IN 1 .. l_event_ids.count
1657: UPDATE ap_payment_history_All APH
1658: SET POSTED_FLAG = 'N'
1659: -- bug 10101613
1660: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1661: ,LAST_UPDATE_DATE = SYSDATE
1662: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1663: WHERE POSTED_FLAG = 'S'
1664: AND APH.accounting_event_id = l_event_ids(i);

Line 1662: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1658: SET POSTED_FLAG = 'N'
1659: -- bug 10101613
1660: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1661: ,LAST_UPDATE_DATE = SYSDATE
1662: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1663: WHERE POSTED_FLAG = 'S'
1664: AND APH.accounting_event_id = l_event_ids(i);
1665:
1666: ---------------------------------------------------------------------

Line 1674: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

1670: FORALL i IN 1 .. l_event_ids.count
1671: UPDATE ap_invoice_payments_all AIP
1672: SET AIP.posted_flag = 'N'
1673: -- bug 10101613
1674: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1675: ,LAST_UPDATE_DATE = SYSDATE
1676: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1677: WHERE POSTED_FLAG = 'S'
1678: AND AIP.accounting_event_id = l_event_ids(i);

Line 1676: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1672: SET AIP.posted_flag = 'N'
1673: -- bug 10101613
1674: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1675: ,LAST_UPDATE_DATE = SYSDATE
1676: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1677: WHERE POSTED_FLAG = 'S'
1678: AND AIP.accounting_event_id = l_event_ids(i);
1679:
1680: END IF;

Line 2136: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

2132: WHEN l_event_status(i) = 'N' THEN 'Y'
2133: ELSE 'N'
2134: END
2135: -- bug 10101613
2136: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2137: ,LAST_UPDATE_DATE = SYSDATE
2138: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2139: WHERE APH.accounting_event_id = l_event_ids(i);
2140:

Line 2138: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2134: END
2135: -- bug 10101613
2136: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2137: ,LAST_UPDATE_DATE = SYSDATE
2138: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2139: WHERE APH.accounting_event_id = l_event_ids(i);
2140:
2141: ---------------------------------------------------------------------
2142: l_debug_info :=

Line 2158: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

2154: WHEN l_event_status(i) = 'N' THEN 'Y'
2155: ELSE 'N'
2156: END
2157: -- bug 10101613
2158: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2159: ,LAST_UPDATE_DATE = SYSDATE
2160: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2161: WHERE APPH.accounting_event_id = l_event_ids(i);
2162:

Line 2160: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2156: END
2157: -- bug 10101613
2158: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2159: ,LAST_UPDATE_DATE = SYSDATE
2160: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2161: WHERE APPH.accounting_event_id = l_event_ids(i);
2162:
2163: ---------------------------------------------------------------------
2164: l_debug_info :=

Line 2193: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

2189: WHEN l_event_status(i) = 'N' THEN 'Y'
2190: ELSE 'N'
2191: END
2192: -- bug 10101613
2193: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2194: ,LAST_UPDATE_DATE = SYSDATE
2195: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2196: WHERE AIP.accounting_event_id = l_event_ids(i);
2197:

Line 2195: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2191: END
2192: -- bug 10101613
2193: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2194: ,LAST_UPDATE_DATE = SYSDATE
2195: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2196: WHERE AIP.accounting_event_id = l_event_ids(i);
2197:
2198: ---------------------------------------------------------------------
2199: l_debug_info :=

Line 2226: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

2222: l_cash_basis_flag = 'Y' THEN 'Y'
2223: ELSE AID.Cash_posted_flag
2224: END
2225: -- bug 10101613
2226: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2227: ,LAST_UPDATE_DATE = SYSDATE
2228: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2229: WHERE AID.accounting_event_id = l_event_ids(i);
2230:

Line 2228: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2224: END
2225: -- bug 10101613
2226: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2227: ,LAST_UPDATE_DATE = SYSDATE
2228: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2229: WHERE AID.accounting_event_id = l_event_ids(i);
2230:
2231: -- bug9444952 : Setting posted flags to appropriate statuses
2232: -- in case the Event_Status_Code is 'N'

Line 2253: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

2249: l_cash_basis_flag = 'Y' THEN 'Y'
2250: ELSE AID.Cash_posted_flag
2251: END
2252: -- bug 10101613
2253: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2254: ,LAST_UPDATE_DATE = SYSDATE
2255: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2256: WHERE AID.accounting_event_id = l_event_ids(i);
2257:

Line 2255: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2251: END
2252: -- bug 10101613
2253: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
2254: ,LAST_UPDATE_DATE = SYSDATE
2255: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2256: WHERE AID.accounting_event_id = l_event_ids(i);
2257:
2258: EXIT WHEN l_events_cur%NOTFOUND;
2259: END LOOP;