DBA Data[Home] [Help]

APPS.OE_HEADER_SCREDIT_UTIL dependencies on OE_SALES_CREDIT_HISTORY

Line 1389: DELETE FROM OE_SALES_CREDIT_HISTORY

1385: );
1386: END LOOP;
1387:
1388: /* Start Audit Trail */
1389: DELETE FROM OE_SALES_CREDIT_HISTORY
1390: WHERE HEADER_ID = p_header_id;
1391: /* End Audit Trail */
1392:
1393: DELETE FROM OE_SALES_CREDITS

Line 1438: DELETE FROM OE_SALES_CREDIT_HISTORY

1434: x_return_status => l_return_status
1435: );
1436:
1437: /* Start Audit Trail (modified for 11.5.10) */
1438: DELETE FROM OE_SALES_CREDIT_HISTORY
1439: WHERE SALES_CREDIT_ID = p_sales_credit_id
1440: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1441: AND NVL(VERSION_FLAG, 'N') = 'N'
1442: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 1444: UPDATE OE_SALES_CREDIT_HISTORY

1440: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1441: AND NVL(VERSION_FLAG, 'N') = 'N'
1442: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
1443:
1444: UPDATE OE_SALES_CREDIT_HISTORY
1445: SET AUDIT_FLAG = 'N'
1446: WHERE SALES_CREDIT_ID = p_sales_credit_id
1447: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1448: AND (NVL(VERSION_FLAG, 'N') = 'Y'