[Home] [Help]
2327:
2328: --Fetch the Price Book Input Lines into a table of records
2329: SELECT * BULK COLLECT
2330: INTO l_pb_input_lines_tbl
2331: FROM qp_pb_input_lines
2332: WHERE pb_input_header_id = p_pb_input_header_id;
2333:
2334: --Perform validation of input criteria
2335: Validate_PB_Input_Criteria(p_pb_input_header_rec => l_pb_input_header_rec,
2905: IF SQL%FOUND THEN
2906: COMMIT;
2907: END IF;
2908:
2909: DELETE FROM QP_PB_INPUT_LINES WHERE PB_INPUT_HEADER_ID in (l_pb_input_header_id, d_pb_input_header_id);
2910: IF SQL%FOUND THEN
2911: COMMIT;
2912: END IF;
2913:
2942: --[prarasto]Deleting the Input Header and Lines is not required as the same header_id will be
2943: --updated in case of an error. Commenting the code.
2944: /*
2945: -- Commiting after each delete as it will give rollback segment error if the data is huge
2946: DELETE FROM QP_PB_INPUT_LINES WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);
2947: IF SQL%FOUND THEN
2948: COMMIT;
2949: END IF;
2950:
4258: BEGIN
4259: SELECT context, attribute, attribute_value, attribute_type
4260: BULK COLLECT INTO l_context_tbl, l_attribute_tbl,
4261: l_attribute_value_tbl, l_attribute_type_tbl
4262: FROM qp_pb_input_lines
4263: WHERE pb_input_header_id = l_full_pb_input_header_rec.pb_input_header_id;
4264: EXCEPTION
4265: WHEN NO_DATA_FOUND THEN
4266: null;
4272: l_user_id := fnd_global.user_id;
4273: l_login_id := fnd_global.login_id;
4274: BEGIN
4275: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
4276: INSERT INTO qp_pb_input_lines
4277: (pb_input_line_id, pb_input_header_id,
4278: context, attribute, attribute_value,
4279: attribute_type, creation_date, created_by, last_update_date,
4280: last_updated_by, last_update_login
4279: attribute_type, creation_date, created_by, last_update_date,
4280: last_updated_by, last_update_login
4281: )
4282: VALUES
4283: (qp_pb_input_lines_s.nextval,
4284: p_pb_input_header_id,
4285: l_context_tbl(k), l_attribute_tbl(k),
4286: l_attribute_value_tbl(k), l_attribute_type_tbl(k),
4287: l_sysdate, l_user_id, l_sysdate, l_user_id, l_login_id
4479: PBInputLIN.ATTRIBUTE_TYPE_VALUE "AttributeTypeValue",
4480: QP_Price_Book_Util.value_to_meaning(''='',''COMPARISON_OPERATOR_FWK'') "OperatorCodeName")
4481: )
4482: )
4483: FROM QP_PB_INPUT_LINES_V PBInputLIN
4484: WHERE PBInputLIN.Pb_Input_Header_Id = PBInputHDR.Pb_Input_Header_Id
4485: )
4486: )
4487: )