DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMO_DATATYPES_GRP

Line 75: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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:

Line 76: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;

Line 77: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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

Line 78: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;

Line 341: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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:

Line 342: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;

Line 343: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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:

Line 344: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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

Line 669: l_form_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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;

Line 670: l_form_source_key_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;

Line 671: l_rout_source_name_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;

Line 672: l_rout_source_key_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;

Line 673: l_source_name_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:

Line 674: l_source_key_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:
678: j PLS_INTEGER;

Line 675: l_target_name_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;
679:

Line 676: l_target_key_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:
680: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1127: l_source_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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:

Line 1128: l_source_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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

Line 1129: l_target_name_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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

Line 1130: l_target_key_array GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;

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: