APPS.INV_SHORTCHECKEXEC_PVT dependencies on DBMS_SQL

Line 100: L_ExecStatement_crs := dbms_sql.open_cursor;

96: END IF;
97: CLOSE L_Statement_crs;
98: --
99: -- Execute statement
100: L_ExecStatement_crs := dbms_sql.open_cursor;
101: dbms_sql.parse(L_ExecStatement_crs,L_Statement,dbms_sql.v7);
102: dbms_sql.bind_variable(L_ExecStatement_crs,':organization_id',
103: p_organization_id);
104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',

Line 101: dbms_sql.parse(L_ExecStatement_crs,L_Statement,dbms_sql.v7);

97: CLOSE L_Statement_crs;
98: --
99: -- Execute statement
100: L_ExecStatement_crs := dbms_sql.open_cursor;
101: dbms_sql.parse(L_ExecStatement_crs,L_Statement,dbms_sql.v7);
102: dbms_sql.bind_variable(L_ExecStatement_crs,':organization_id',
103: p_organization_id);
104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',
105: p_inventory_item_id);

Line 102: dbms_sql.bind_variable(L_ExecStatement_crs,':organization_id',

98: --
99: -- Execute statement
100: L_ExecStatement_crs := dbms_sql.open_cursor;
101: dbms_sql.parse(L_ExecStatement_crs,L_Statement,dbms_sql.v7);
102: dbms_sql.bind_variable(L_ExecStatement_crs,':organization_id',
103: p_organization_id);
104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',
105: p_inventory_item_id);
106: -- If statement type is summary then bind wip and oe short quantity

Line 104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',

100: L_ExecStatement_crs := dbms_sql.open_cursor;
101: dbms_sql.parse(L_ExecStatement_crs,L_Statement,dbms_sql.v7);
102: dbms_sql.bind_variable(L_ExecStatement_crs,':organization_id',
103: p_organization_id);
104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',
105: p_inventory_item_id);
106: -- If statement type is summary then bind wip and oe short quantity
107: IF p_sum_detail_flag = 2 THEN
108: dbms_sql.bind_variable(L_ExecStatement_crs,':wip_short_quantity',

Line 108: dbms_sql.bind_variable(L_ExecStatement_crs,':wip_short_quantity',

104: dbms_sql.bind_variable(L_ExecStatement_crs,':inventory_item_id',
105: p_inventory_item_id);
106: -- If statement type is summary then bind wip and oe short quantity
107: IF p_sum_detail_flag = 2 THEN
108: dbms_sql.bind_variable(L_ExecStatement_crs,':wip_short_quantity',
109: 0);
110: dbms_sql.bind_variable(L_ExecStatement_crs,':oe_short_quantity',
111: 0);
112: END IF;

Line 110: dbms_sql.bind_variable(L_ExecStatement_crs,':oe_short_quantity',

106: -- If statement type is summary then bind wip and oe short quantity
107: IF p_sum_detail_flag = 2 THEN
108: dbms_sql.bind_variable(L_ExecStatement_crs,':wip_short_quantity',
109: 0);
110: dbms_sql.bind_variable(L_ExecStatement_crs,':oe_short_quantity',
111: 0);
112: END IF;
113: -- If statement type is detail then pull sequence number and bind it
114: IF p_sum_detail_flag = 1 THEN

Line 119: dbms_sql.bind_variable(L_ExecStatement_crs,':seq_num',

115: SELECT mtl_short_chk_temp_s.NEXTVAL
116: INTO x_seq_num
117: FROM dual;
118: --
119: dbms_sql.bind_variable(L_ExecStatement_crs,':seq_num',
120: x_seq_num);
121: ELSE
122: x_seq_num := NULL;
123: END IF;

Line 124: L_RowsProcessed := dbms_sql.execute(L_ExecStatement_crs);

120: x_seq_num);
121: ELSE
122: x_seq_num := NULL;
123: END IF;
124: L_RowsProcessed := dbms_sql.execute(L_ExecStatement_crs);
125: -- If statement type is summary then pick up the wip and oe
126: -- short quantity
127: IF p_sum_detail_flag = 2 THEN
128: dbms_sql.variable_value(L_ExecStatement_crs,':wip_short_quantity',

Line 128: dbms_sql.variable_value(L_ExecStatement_crs,':wip_short_quantity',

124: L_RowsProcessed := dbms_sql.execute(L_ExecStatement_crs);
125: -- If statement type is summary then pick up the wip and oe
126: -- short quantity
127: IF p_sum_detail_flag = 2 THEN
128: dbms_sql.variable_value(L_ExecStatement_crs,':wip_short_quantity',
129: x_wip_short_quantity);
130: dbms_sql.variable_value(L_ExecStatement_crs,':oe_short_quantity',
131: x_oe_short_quantity);
132: END IF;

Line 130: dbms_sql.variable_value(L_ExecStatement_crs,':oe_short_quantity',

126: -- short quantity
127: IF p_sum_detail_flag = 2 THEN
128: dbms_sql.variable_value(L_ExecStatement_crs,':wip_short_quantity',
129: x_wip_short_quantity);
130: dbms_sql.variable_value(L_ExecStatement_crs,':oe_short_quantity',
131: x_oe_short_quantity);
132: END IF;
133: dbms_sql.close_cursor(L_ExecStatement_crs);
134: END ExecStatement;

Line 133: dbms_sql.close_cursor(L_ExecStatement_crs);

129: x_wip_short_quantity);
130: dbms_sql.variable_value(L_ExecStatement_crs,':oe_short_quantity',
131: x_oe_short_quantity);
132: END IF;
133: dbms_sql.close_cursor(L_ExecStatement_crs);
134: END ExecStatement;
135: --
136: FUNCTION Compare (
137: p_organization_id IN NUMBER,