APPS.OE_LINE_SCREDIT_UTIL dependencies on OE_SALES_CREDITS

Line 1173: FROM OE_SALES_CREDITS

1169: END IF;
1170:
1171: SELECT lock_control
1172: INTO l_lock_control
1173: FROM OE_SALES_CREDITS
1174: WHERE sales_credit_id = p_Line_Scredit_rec.sales_credit_id;
1175:
1176: l_lock_control := l_lock_control + 1;
1177:

Line 1191: UPDATE OE_SALES_CREDITS

1187: oe_debug_pub.add( 'BEFORE UPDATE , SALES_CREDIT_ID= '|| L_LINE_SCREDIT_REC.SALES_CREDIT_ID , 1 ) ;
1188: END IF;
1189: /* jolin end*/
1190:
1191: UPDATE OE_SALES_CREDITS
1192: SET ATTRIBUTE1 = p_Line_Scredit_rec.attribute1
1193: , ATTRIBUTE10 = p_Line_Scredit_rec.attribute10
1194: , ATTRIBUTE11 = p_Line_Scredit_rec.attribute11
1195: , ATTRIBUTE12 = p_Line_Scredit_rec.attribute12

Line 1317: INSERT INTO OE_SALES_CREDITS

1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1315: END IF;
1316:
1317: INSERT INTO OE_SALES_CREDITS
1318: ( ATTRIBUTE1
1319: , ATTRIBUTE10
1320: , ATTRIBUTE11
1321: , ATTRIBUTE12

Line 1473: FROM OE_SALES_CREDITS

1469: /* jolin end*/
1470:
1471: CURSOR sales_credit IS
1472: SELECT sales_credit_id
1473: FROM OE_SALES_CREDITS
1474: WHERE LINE_ID = p_line_id;
1475: --
1476: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1477: --

Line 1560: DELETE FROM OE_SALES_CREDITS

1556: AND (NVL(VERSION_FLAG, 'N') = 'Y'
1557: OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
1558: /* End Audit Trail */
1559:
1560: DELETE FROM OE_SALES_CREDITS
1561: WHERE LINE_ID = p_line_id;
1562:
1563: ELSE
1564:

Line 1635: DELETE FROM OE_SALES_CREDITS

1631: AND (NVL(VERSION_FLAG, 'N') = 'Y'
1632: OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
1633: /* End Audit Trail */
1634:
1635: DELETE FROM OE_SALES_CREDITS
1636: WHERE SALES_CREDIT_ID = p_sales_credit_id
1637: ;
1638: END IF;
1639:

Line 1735: FROM OE_SALES_CREDITS

1731: , SALES_GROUP_ID
1732: , SALES_GROUP_UPDATED_FLAG
1733: --SG }
1734: , LOCK_CONTROL
1735: FROM OE_SALES_CREDITS
1736: WHERE SALES_CREDIT_ID = p_sales_credit_id;
1737:
1738: CURSOR l_Line_Scredit_csr_l IS
1739: SELECT ATTRIBUTE1

Line 1773: FROM OE_SALES_CREDITS

1769: , SALES_GROUP_ID
1770: , SALES_GROUP_UPDATED_FLAG
1771: --SG }
1772: , LOCK_CONTROL
1773: FROM OE_SALES_CREDITS
1774: WHERE LINE_ID = p_line_id;
1775:
1776: CURSOR l_Line_Scredit_csr_h IS
1777: SELECT ATTRIBUTE1

Line 1811: FROM OE_SALES_CREDITS

1807: , SALES_GROUP_ID
1808: , SALES_GROUP_UPDATED_FLAG
1809: --SG }
1810: , LOCK_CONTROL
1811: FROM OE_SALES_CREDITS
1812: WHERE HEADER_ID = p_header_id
1813: AND LINE_ID IS NOT NULL;
1814:
1815: l_implicit_rec l_line_scredit_csr_s%ROWTYPE;

Line 1996: FROM oe_sales_credits

1992: END IF;
1993:
1994: SELECT sales_credit_id
1995: INTO l_sales_credit_id
1996: FROM oe_sales_credits
1997: WHERE sales_credit_id = l_sales_credit_id
1998: FOR UPDATE NOWAIT;
1999:
2000: IF l_debug_level > 0 THEN

Line 2110: FROM oe_sales_credits

2106: )
2107: IS
2108: CURSOR lock_line_scredits(p_line_id NUMBER) IS
2109: SELECT sales_credit_id
2110: FROM oe_sales_credits
2111: WHERE line_id = p_line_id
2112: FOR UPDATE NOWAIT;
2113:
2114: l_sales_credit_id NUMBER;

Line 2146: FROM OE_SALES_CREDITS

2142: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
2143:
2144: SELECT sales_credit_id
2145: INTO l_sales_credit_id
2146: FROM OE_SALES_CREDITS
2147: WHERE sales_credit_id = p_sales_credit_id
2148: FOR UPDATE NOWAIT;
2149:
2150: END IF;

Line 2376: from oe_sales_credits sc,

2372: l_notify_index Number;
2373:
2374: Cursor C_LSC_COUNT IS
2375: Select count(sales_credit_id), max(sales_credit_id)
2376: from oe_sales_credits sc,
2377: oe_sales_credit_types sct
2378: where header_id = p_line_rec.header_id
2379: and sc.sales_credit_type_id = sct.sales_credit_type_id
2380: and sct.quota_flag = 'Y'