DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PUB dependencies on CST_LC_ADJ_INTERFACE

Line 70: FROM cst_lc_adj_interface

66: CURSOR c_org IS
67: SELECT organization_id, primary_cost_method
68: FROM mtl_parameters mp
69: WHERE EXISTS (SELECT 1
70: FROM cst_lc_adj_interface
71: WHERE organization_id = mp.organization_id
72: AND process_status IN (1,2));
73: BEGIN
74:

Line 110: UPDATE cst_lc_adj_interface i

106: INTO l_group_id
107: FROM DUAL;
108:
109: l_stmt_num := 50;
110: UPDATE cst_lc_adj_interface i
111: SET transaction_id = NVL(transaction_id, CST_LC_ADJ_INTERFACE_TRX_S.NEXTVAL),
112: group_id = l_group_id,
113: request_id = fnd_global.conc_request_id,
114: process_phase = 2

Line 111: SET transaction_id = NVL(transaction_id, CST_LC_ADJ_INTERFACE_TRX_S.NEXTVAL),

107: FROM DUAL;
108:
109: l_stmt_num := 50;
110: UPDATE cst_lc_adj_interface i
111: SET transaction_id = NVL(transaction_id, CST_LC_ADJ_INTERFACE_TRX_S.NEXTVAL),
112: group_id = l_group_id,
113: request_id = fnd_global.conc_request_id,
114: process_phase = 2
115: WHERE organization_id = c_o.organization_id

Line 154: UPDATE cst_lc_adj_interface

150: argument2 => to_char(c_o.organization_id));
151:
152: IF l_request_id = 0 THEN
153: l_stmt_num := 80;
154: UPDATE cst_lc_adj_interface
155: SET group_id = NULL,
156: process_phase = 1
157: WHERE group_id = l_group_id
158: AND organization_id = c_o.organization_id;