DBA Data[Home] [Help]

APPS.OE_INF_POPULATE_PUB dependencies on OE_CREDITS_IFACE_ALL

Line 1686: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;

1682: END IF;
1683: END IF;
1684:
1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1687: END IF;
1688: /* Header Level Sales Credits */
1689: INSERT INTO OE_CREDITS_IFACE_ALL (
1690: SALESREP /*VARCHAR2(30)*/

Line 1689: INSERT INTO OE_CREDITS_IFACE_ALL (

1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1687: END IF;
1688: /* Header Level Sales Credits */
1689: INSERT INTO OE_CREDITS_IFACE_ALL (
1690: SALESREP /*VARCHAR2(30)*/
1691: , SALES_CREDIT_TYPE_ID /*NUMBER(22)*/
1692: , SALES_CREDIT_TYPE /*VARCHAR2(30)*/
1693: , QUOTA_FLAG /*VARCHAR2(1)*/

Line 1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

1782: and line_id is null;
1783:
1784: IF SQL%ROWCOUNT > 0 THEN
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1787: END IF;
1788: ELSE
1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

Line 1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;

1786: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1787: END IF;
1788: ELSE
1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR HEADER' ) ;
1791: END IF;
1792: END IF;
1793:
1794: IF l_debug_level > 0 THEN

Line 1795: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;

1791: END IF;
1792: END IF;
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1796: END IF;
1797:
1798: /* Line Level Sales Credits */
1799: INSERT INTO OE_CREDITS_IFACE_ALL (

Line 1799: INSERT INTO OE_CREDITS_IFACE_ALL (

1795: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_CREDITS_IFACE_ALL' ) ;
1796: END IF;
1797:
1798: /* Line Level Sales Credits */
1799: INSERT INTO OE_CREDITS_IFACE_ALL (
1800: SALESREP /*VARCHAR2(30)*/
1801: , SALES_CREDIT_TYPE_ID /*NUMBER(22)*/
1802: , SALES_CREDIT_TYPE /*VARCHAR2(30)*/
1803: , QUOTA_FLAG /*VARCHAR2(1)*/

Line 1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

1892: and line_id is not null;
1893:
1894: IF SQL%ROWCOUNT > 0 THEN
1895: IF l_debug_level > 0 THEN
1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1897: END IF;
1898: ELSE
1899: IF l_debug_level > 0 THEN
1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

Line 1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;

1896: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1897: END IF;
1898: ELSE
1899: IF l_debug_level > 0 THEN
1900: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_CREDITS_IFACE_ALL FOR LINES' ) ;
1901: END IF;
1902: END IF;
1903:
1904: IF l_debug_level > 0 THEN