APPS.OE_LINE_SCREDIT_UTIL dependencies on OE_SALES_CREDIT_HISTORY

Line 1546: DELETE FROM OE_SALES_CREDIT_HISTORY

1542:
1543: END LOOP;
1544:
1545: /* Start Audit Trail (modified for 11.5.10) */
1546: DELETE FROM OE_SALES_CREDIT_HISTORY
1547: WHERE LINE_ID = p_line_id
1548: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1549: AND NVL(VERSION_FLAG, 'N') = 'N'
1550: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 1552: UPDATE OE_SALES_CREDIT_HISTORY

1548: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1549: AND NVL(VERSION_FLAG, 'N') = 'N'
1550: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
1551:
1552: UPDATE OE_SALES_CREDIT_HISTORY
1553: SET AUDIT_FLAG = 'N'
1554: WHERE LINE_ID = p_line_id
1555: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1556: AND (NVL(VERSION_FLAG, 'N') = 'Y'

Line 1621: DELETE FROM OE_SALES_CREDIT_HISTORY

1617: x_return_status => l_return_status
1618: );
1619:
1620: /* Start Audit Trail (modified for 11.5.10)*/
1621: DELETE FROM OE_SALES_CREDIT_HISTORY
1622: WHERE SALES_CREDIT_ID = p_sales_credit_id
1623: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1624: AND NVL(VERSION_FLAG, 'N') = 'N'
1625: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 1627: UPDATE OE_SALES_CREDIT_HISTORY

1623: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1624: AND NVL(VERSION_FLAG, 'N') = 'N'
1625: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
1626:
1627: UPDATE OE_SALES_CREDIT_HISTORY
1628: SET AUDIT_FLAG = 'N'
1629: WHERE SALES_CREDIT_ID = p_sales_credit_id
1630: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
1631: AND (NVL(VERSION_FLAG, 'N') = 'Y'