71: l_ret NUMBER;
72: VALIDATION_FAILURE EXCEPTION;
73:
74: l_gmo_enabled VARCHAR2(1);
75: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
76: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
77: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
78: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
79:
72: VALIDATION_FAILURE EXCEPTION;
73:
74: l_gmo_enabled VARCHAR2(1);
75: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
76: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
77: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
78: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
79:
80: PRAGMA AUTONOMOUS_TRANSACTION;
73:
74: l_gmo_enabled VARCHAR2(1);
75: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
76: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
77: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
78: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
79:
80: PRAGMA AUTONOMOUS_TRANSACTION;
81: BEGIN
74: l_gmo_enabled VARCHAR2(1);
75: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
76: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
77: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
78: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
79:
80: PRAGMA AUTONOMOUS_TRANSACTION;
81: BEGIN
82: OPEN Cur_get_hdr;
337: X_message_list VARCHAR2(2000);
338: l_entity_status gmd_api_grp.status_rec_type;
339:
340: l_gmo_enabled VARCHAR2(1);
341: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
342: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
343: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
344: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
345:
338: l_entity_status gmd_api_grp.status_rec_type;
339:
340: l_gmo_enabled VARCHAR2(1);
341: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
342: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
343: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
344: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
345:
346: PRAGMA AUTONOMOUS_TRANSACTION;
339:
340: l_gmo_enabled VARCHAR2(1);
341: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
342: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
343: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
344: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
345:
346: PRAGMA AUTONOMOUS_TRANSACTION;
347:
340: l_gmo_enabled VARCHAR2(1);
341: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
342: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
343: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
344: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
345:
346: PRAGMA AUTONOMOUS_TRANSACTION;
347:
348: BEGIN
665: X_message_count NUMBER;
666: X_message_list VARCHAR2(2000);
667: l_entity_status gmd_api_grp.status_rec_type;
668:
669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
666: X_message_list VARCHAR2(2000);
667: l_entity_status gmd_api_grp.status_rec_type;
668:
669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
667: l_entity_status gmd_api_grp.status_rec_type;
668:
669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
668:
669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
676: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
676: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
677:
670: l_form_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
676: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
677:
678: j PLS_INTEGER;
671: l_rout_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
676: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
677:
678: j PLS_INTEGER;
679:
672: l_rout_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
673: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
674: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
675: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
676: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
677:
678: j PLS_INTEGER;
679:
680: PRAGMA AUTONOMOUS_TRANSACTION;
1123: X_recipe_version NUMBER;
1124: X_creation_type NUMBER(5);
1125:
1126: l_gmo_enabled VARCHAR2(1);
1127: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1128: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1129: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1130: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1131:
1124: X_creation_type NUMBER(5);
1125:
1126: l_gmo_enabled VARCHAR2(1);
1127: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1128: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1129: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1130: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1131:
1132: -- Bug No.5985327 - Start
1125:
1126: l_gmo_enabled VARCHAR2(1);
1127: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1128: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1129: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1130: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1131:
1132: -- Bug No.5985327 - Start
1133: --Created new variables to retrieve the output quantity from GMD_COMMON_VAL.calculate_total_qty procedure
1126: l_gmo_enabled VARCHAR2(1);
1127: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1128: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1129: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1130: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;
1131:
1132: -- Bug No.5985327 - Start
1133: --Created new variables to retrieve the output quantity from GMD_COMMON_VAL.calculate_total_qty procedure
1134: