APPS.GMI_ALLOCATION_RULES_PVT dependencies on OP_CUST_MST

Line 33: ( p_co_code IN OP_CUST_MST.CO_CODE%TYPE default NULL

29: -- HW BUG#:2643440, removed intitalization of G_MISS_XXX
30: -- from p_co_code,p_cust_no, p_alloc_class,p_of_cust_id,
31: -- p_ship_to_org_id,p_org_id.
32: PROCEDURE GET_ALLOCATION_PARMS
33: ( p_co_code IN OP_CUST_MST.CO_CODE%TYPE default NULL
34: , p_cust_no IN OP_CUST_MST.CUST_NO%TYPE default NULL
35: , p_alloc_class IN IC_ITEM_MST.ALLOC_CLASS%TYPE default NULL
36: , p_of_cust_id IN NUMBER default NULL
37: , p_ship_to_org_id IN NUMBER default NULL

Line 34: , p_cust_no IN OP_CUST_MST.CUST_NO%TYPE default NULL

30: -- from p_co_code,p_cust_no, p_alloc_class,p_of_cust_id,
31: -- p_ship_to_org_id,p_org_id.
32: PROCEDURE GET_ALLOCATION_PARMS
33: ( p_co_code IN OP_CUST_MST.CO_CODE%TYPE default NULL
34: , p_cust_no IN OP_CUST_MST.CUST_NO%TYPE default NULL
35: , p_alloc_class IN IC_ITEM_MST.ALLOC_CLASS%TYPE default NULL
36: , p_of_cust_id IN NUMBER default NULL
37: , p_ship_to_org_id IN NUMBER default NULL
38: , p_org_id IN NUMBER default NULL

Line 46: l_cust_id OP_CUST_MST.CUST_ID%TYPE;

42: , x_msg_data OUT NOCOPY VARCHAR2
43: )
44: IS
45: l_api_name CONSTANT VARCHAR2 (30) := 'GET_ALLOCATION_PARMS';
46: l_cust_id OP_CUST_MST.CUST_ID%TYPE;
47: l_msg_count NUMBER :=0;
48: l_msg_data VARCHAR2(2000);
49: l_return_status VARCHAR2(1);
50: l_op_alot_prm OP_ALOT_PRM%ROWTYPE;

Line 52: CURSOR op_cust_mst_c1 is

48: l_msg_data VARCHAR2(2000);
49: l_return_status VARCHAR2(1);
50: l_op_alot_prm OP_ALOT_PRM%ROWTYPE;
51:
52: CURSOR op_cust_mst_c1 is
53: SELECT cust_id
54: FROM op_cust_mst
55: WHERE co_code = p_co_code and cust_no = p_cust_no;
56:

Line 54: FROM op_cust_mst

50: l_op_alot_prm OP_ALOT_PRM%ROWTYPE;
51:
52: CURSOR op_cust_mst_c1 is
53: SELECT cust_id
54: FROM op_cust_mst
55: WHERE co_code = p_co_code and cust_no = p_cust_no;
56:
57: --BUG 1655007 - Ensure delete_marked rows are ignored
58: --===================================================

Line 91: /* OPEN op_cust_mst_c1;

87: and delete_mark=0;
88:
89: BEGIN
90:
91: /* OPEN op_cust_mst_c1;
92: FETCH op_cust_mst_c1 INTO l_cust_id;
93:
94: IF (op_cust_mst_c1%NOTFOUND)
95: THEN

Line 92: FETCH op_cust_mst_c1 INTO l_cust_id;

88:
89: BEGIN
90:
91: /* OPEN op_cust_mst_c1;
92: FETCH op_cust_mst_c1 INTO l_cust_id;
93:
94: IF (op_cust_mst_c1%NOTFOUND)
95: THEN
96: CLOSE op_cust_mst_c1;

Line 94: IF (op_cust_mst_c1%NOTFOUND)

90:
91: /* OPEN op_cust_mst_c1;
92: FETCH op_cust_mst_c1 INTO l_cust_id;
93:
94: IF (op_cust_mst_c1%NOTFOUND)
95: THEN
96: CLOSE op_cust_mst_c1;
97: FND_MESSAGE.SET_NAME('GML','OP_API_INVALID_CUSTOMER');
98: FND_MESSAGE.SET_TOKEN('CUST_NO',p_cust_no);

Line 96: CLOSE op_cust_mst_c1;

92: FETCH op_cust_mst_c1 INTO l_cust_id;
93:
94: IF (op_cust_mst_c1%NOTFOUND)
95: THEN
96: CLOSE op_cust_mst_c1;
97: FND_MESSAGE.SET_NAME('GML','OP_API_INVALID_CUSTOMER');
98: FND_MESSAGE.SET_TOKEN('CUST_NO',p_cust_no);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;

Line 102: CLOSE op_cust_mst_c1;

98: FND_MESSAGE.SET_TOKEN('CUST_NO',p_cust_no);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: ELSE
102: CLOSE op_cust_mst_c1;
103: END IF;
104: */
105: /*Attempt to locate allocation parms specific to this customer
106: =============================================================*/