APPS.OE_HEADER_SCREDIT_UTIL dependencies on OE_SALES_CREDITS

Line 1072: FROM OE_SALES_CREDITS

1068: BEGIN
1069:
1070: SELECT lock_control
1071: INTO l_lock_control
1072: FROM OE_SALES_CREDITS
1073: WHERE sales_credit_id = p_Header_Scredit_rec.sales_credit_id;
1074:
1075: l_lock_control := l_lock_control + 1;
1076:

Line 1111: UPDATE OE_SALES_CREDITS

1107: END IF;
1108: END IF; /*code_release_level*/
1109: -- notification framework end
1110:
1111: UPDATE OE_SALES_CREDITS
1112: SET ATTRIBUTE1 = p_Header_Scredit_rec.attribute1
1113: , ATTRIBUTE10 = p_Header_Scredit_rec.attribute10
1114: , ATTRIBUTE11 = p_Header_Scredit_rec.attribute11
1115: , ATTRIBUTE12 = p_Header_Scredit_rec.attribute12

Line 1184: INSERT INTO OE_SALES_CREDITS

1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1182: END IF;
1183:
1184: INSERT INTO OE_SALES_CREDITS
1185: ( ATTRIBUTE1
1186: , ATTRIBUTE10
1187: , ATTRIBUTE11
1188: , ATTRIBUTE12

Line 1329: FROM OE_SALES_CREDITS

1325: IS
1326: l_return_status VARCHAR2(30);
1327: CURSOR sales_credit IS
1328: SELECT sales_credit_id
1329: FROM OE_SALES_CREDITS
1330: WHERE HEADER_ID = p_header_id;
1331: -- added for notification framework
1332: l_new_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1333: l_index NUMBER;

Line 1393: DELETE FROM OE_SALES_CREDITS

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
1394: WHERE HEADER_ID = p_header_id;
1395: ELSE
1396: --added notification framework
1397: --check code release level first. Notification framework is at Pack H level

Line 1452: DELETE FROM OE_SALES_CREDITS

1448: AND (NVL(VERSION_FLAG, 'N') = 'Y'
1449: OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
1450: /* End Audit Trail */
1451:
1452: DELETE FROM OE_SALES_CREDITS
1453: WHERE SALES_CREDIT_ID = p_sales_credit_id
1454: ;
1455: END IF;
1456:

Line 1544: FROM OE_SALES_CREDITS

1540: , SALES_GROUP_ID
1541: , SALES_GROUP_UPDATED_FLAG
1542: --SG }
1543: , LOCK_CONTROL
1544: FROM OE_SALES_CREDITS
1545: WHERE SALES_CREDIT_ID = p_sales_credit_id;
1546:
1547: CURSOR l_Header_Scredit_csr_h IS
1548: SELECT ATTRIBUTE1

Line 1582: FROM OE_SALES_CREDITS

1578: , SALES_GROUP_ID
1579: , SALES_GROUP_UPDATED_FLAG
1580: --SG }
1581: , LOCK_CONTROL
1582: FROM OE_SALES_CREDITS
1583: WHERE HEADER_ID = p_header_id
1584: AND LINE_ID IS NULL;
1585:
1586: l_implicit_rec l_header_scredit_csr_s%ROWTYPE;

Line 1753: FROM oe_sales_credits

1749: END IF;
1750:
1751: SELECT sales_credit_id
1752: INTO l_sales_credit_id
1753: FROM oe_sales_credits
1754: WHERE sales_credit_id = l_sales_credit_id
1755: FOR UPDATE NOWAIT;
1756:
1757: IF l_debug_level > 0 THEN

Line 1867: FROM oe_sales_credits

1863: )
1864: IS
1865: CURSOR lock_hdr_scredits(p_header_id NUMBER) IS
1866: SELECT sales_credit_id
1867: FROM oe_sales_credits
1868: WHERE header_id = p_header_id
1869: FOR UPDATE NOWAIT;
1870:
1871: l_sales_credit_id NUMBER;

Line 1903: FROM OE_SALES_CREDITS

1899: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1900:
1901: SELECT sales_credit_id
1902: INTO l_sales_credit_id
1903: FROM OE_SALES_CREDITS
1904: WHERE sales_credit_id = p_sales_credit_id
1905: FOR UPDATE NOWAIT;
1906:
1907: END IF;

Line 2300: FROM oe_sales_credits sc,

2296: l_sales_credit_id Number;
2297:
2298: CURSOR C_HSC_COUNT(p_header_id Number) IS
2299: SELECT count(sales_credit_id), max(sales_credit_id)
2300: FROM oe_sales_credits sc,
2301: oe_sales_credit_types sct
2302: WHERE header_id = p_header_id
2303: AND sct.sales_credit_type_id = sc.sales_credit_type_id
2304: AND sct.quota_flag = 'Y'

Line 2558: From OE_SALES_CREDITS

2554: Cursor none_fixed_sales_group IS
2555: Select salesrep_id,
2556: sales_credit_id,
2557: sales_group_id
2558: From OE_SALES_CREDITS
2559: Where Sales_Group_Updated_Flag = 'N'
2560: And header_id = p_header_id;
2561:
2562: l_sales_credit_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

Line 2606: UPDATE OE_SALES_CREDITS

2602: End Loop;
2603:
2604: IF l_sales_credit_id_tbl.count > 0 THEN
2605: FORALL i in l_sales_credit_id_tbl.FIRST .. l_sales_credit_id_tbl.LAST
2606: UPDATE OE_SALES_CREDITS
2607: SET Sales_Group_Id = l_sales_group_id_tbl(i)
2608: WHERE Sales_Credit_Id = l_sales_credit_id_tbl(i);
2609: END IF;
2610: