APPS.AP_SLA_PROCESSING_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 213: UPDATE ap_self_assessed_tax_dist_all STID

209: WHERE AID.accounting_event_id = p_event_ids(i);
210:
211: -- bug fix 6975868
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

Line 814: UPDATE ap_self_assessed_tax_dist_all

810: -----------------------------------------------------------------------
811:
812: -- bug fix 6975868 begin
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

Line 977: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID

973: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
974: -----------------------------------------------------------------------
975:
976: FORALL num in 1 .. l_prepay_event_list.COUNT
977: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID
978: SET STID.Posted_Flag = 'Y',
979: STID.Accrual_Posted_Flag = 'N',
980: STID.Cash_Posted_Flag = 'Y'
981: -- bug 10101613

Line 1155: UPDATE ap_self_assessed_tax_dist_all STID

1151: l_prepay_event_list.COUNT;
1152: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1153: -----------------------------------------------------------------------
1154: FORALL num in 1 .. l_prepay_event_list.COUNT
1155: UPDATE ap_self_assessed_tax_dist_all STID
1156: SET STID.Posted_Flag = 'Y', STID.Accrual_Posted_Flag = 'N' , --9698155
1157: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1158: l_prepay_event_list(num),
1159: STID.Invoice_Distribution_ID,

Line 1279: UPDATE ap_self_assessed_tax_dist_all STID

1275: l_payclear_event_list.COUNT;
1276: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1277: -----------------------------------------------------------------------
1278: FORALL num in 1 .. l_payclear_event_list.COUNT
1279: UPDATE ap_self_assessed_tax_dist_all STID
1280: SET STID.Posted_Flag = 'Y', STID.Accrual_Posted_Flag = 'N' ,
1281: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1282: l_payclear_event_list(num),
1283: STID.Invoice_Distribution_ID,

Line 1401: UPDATE ap_self_assessed_tax_dist_all STID

1397: l_other_event_list.COUNT;
1398: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1399: -----------------------------------------------------------------------
1400: FORALL num in 1 .. l_other_event_list.COUNT
1401: UPDATE ap_self_assessed_tax_dist_all STID
1402: SET STID.Posted_Flag = 'Y', STID.Accrual_Posted_Flag = 'N' ,
1403: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1404: l_other_event_list(num),
1405: STID.Invoice_Distribution_ID,

Line 1508: UPDATE ap_self_assessed_tax_dist_all STID

1504: l_other_event_list.COUNT;
1505: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1506: -----------------------------------------------------------------------
1507: FORALL num in 1 .. l_cash_inv_event_list.COUNT
1508: UPDATE ap_self_assessed_tax_dist_all STID
1509: SET STID.Posted_Flag = 'Y',
1510: STID.Accrual_Posted_Flag = 'N' ,
1511: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1512: l_cash_inv_event_list(num),

Line 1765: UPDATE ap_self_assessed_tax_dist_all AID

1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in
1763: ( select event_id from xla_events_gt);
1764:
1765: UPDATE ap_self_assessed_tax_dist_all AID
1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in
1768: ( select event_id from xla_events_gt);
1769:

Line 2235: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL AID

2231: -- bug9444952 : Setting posted flags to appropriate statuses
2232: -- in case the Event_Status_Code is 'N'
2233: --
2234: FORALL i IN 1 .. l_event_ids.count
2235: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL AID
2236: SET AID.posted_flag = CASE
2237: WHEN l_event_status(i) = 'N' THEN 'Y'
2238: ELSE 'N'
2239: END,