APPS.AP_SLA_PROCESSING_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 192: UPDATE ap_self_assessed_tax_dist_all STID

188: WHERE AID.accounting_event_id = p_event_ids(i);
189:
190: -- bug fix 6975868
191: FORALL i IN 1 .. p_event_ids.count
192: UPDATE ap_self_assessed_tax_dist_all STID
193: SET STID.posted_flag = 'S'
194: WHERE STID.accounting_event_id = p_event_ids(i);
195:
196: ---------------------------------------------------------------------

Line 758: UPDATE ap_self_assessed_tax_dist_all

754: -----------------------------------------------------------------------
755:
756: -- bug fix 6975868 begin
757: FORALL num in 1 .. l_accrual_event_ids.COUNT
758: UPDATE ap_self_assessed_tax_dist_all
759: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
760: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
761: RETURNING detail_tax_dist_id
762: BULK COLLECT INTO l_tax_dist_id_list1;

Line 909: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID

905: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
906: -----------------------------------------------------------------------
907:
908: FORALL num in 1 .. l_prepay_event_list.COUNT
909: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID
910: SET STID.Posted_Flag = 'Y',
911: STID.Accrual_Posted_Flag = 'N',
912: STID.Cash_Posted_Flag = 'Y'
913: WHERE STID.Accounting_Event_ID = l_prepay_event_list(num)

Line 1021: UPDATE ap_self_assessed_tax_dist_all STID

1017: l_prepay_event_list.COUNT;
1018: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1019: -----------------------------------------------------------------------
1020: FORALL num in 1 .. l_prepay_event_list.COUNT
1021: UPDATE ap_self_assessed_tax_dist_all STID
1022: SET STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1023: l_prepay_event_list(num),
1024: STID.Invoice_Distribution_ID,
1025: STID.Amount,

Line 1134: UPDATE ap_self_assessed_tax_dist_all STID

1130: l_payclear_event_list.COUNT;
1131: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1132: -----------------------------------------------------------------------
1133: FORALL num in 1 .. l_payclear_event_list.COUNT
1134: UPDATE ap_self_assessed_tax_dist_all STID
1135: SET STID.Posted_Flag = 'Y', STID.Accrual_Posted_Flag = 'N' ,
1136: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1137: l_payclear_event_list(num),
1138: STID.Invoice_Distribution_ID,

Line 1246: UPDATE ap_self_assessed_tax_dist_all STID

1242: l_other_event_list.COUNT;
1243: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1244: -----------------------------------------------------------------------
1245: FORALL num in 1 .. l_other_event_list.COUNT
1246: UPDATE ap_self_assessed_tax_dist_all STID
1247: SET STID.Posted_Flag = 'Y', STID.Accrual_Posted_Flag = 'N' ,
1248: STID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1249: l_other_event_list(num),
1250: STID.Invoice_Distribution_ID,

Line 1490: UPDATE ap_self_assessed_tax_dist_all AID

1486: SET POSTED_FLAG = 'N'
1487: WHERE AID.accounting_event_id in
1488: ( select event_id from xla_events_gt);
1489:
1490: UPDATE ap_self_assessed_tax_dist_all AID
1491: SET POSTED_FLAG = 'N'
1492: WHERE AID.accounting_event_id in
1493: ( select event_id from xla_events_gt);
1494:

Line 1917: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID

1913: SET AID.posted_flag = 'N'
1914: WHERE AID.accounting_event_id = l_event_ids(i);
1915:
1916: FORALL i IN 1 .. l_event_ids.count
1917: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL STID
1918: SET STID.posted_flag = 'N'
1919: WHERE STID.accounting_event_id = l_event_ids(i);
1920:
1921: EXIT WHEN l_events_cur%NOTFOUND;