eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_COPY_UDAS_GRP dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 53: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

49:
50: PROCEDURE AUTO_CREATE_UDA_COPY(
51: from_template_id IN NUMBER
52: ,to_template_id IN NUMBER
53: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
54: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
55: ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSION
56: ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 54: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

50: PROCEDURE AUTO_CREATE_UDA_COPY(
51: from_template_id IN NUMBER
52: ,to_template_id IN NUMBER
53: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
54: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
55: ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSION
56: ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2

Line 96: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY

92: END;
93:
94: FUNCTION GET_EGO_COL_NAM_VAL_PAIR(p_key in PKeyList,
95: p_key_name in PKeyCol)
96: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
97: IS
98: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
99: BEGIN
100: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

Line 98: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

94: FUNCTION GET_EGO_COL_NAM_VAL_PAIR(p_key in PKeyList,
95: p_key_name in PKeyCol)
96: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
97: IS
98: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
99: BEGIN
100: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
101: FOR i in p_key.FIRST .. p_key.LAST
102: LOOP

Line 100: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

96: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY
97: IS
98: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
99: BEGIN
100: pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
101: FOR i in p_key.FIRST .. p_key.LAST
102: LOOP
103: pk_col_value_pairs.extend;
104: pk_col_value_pairs(i) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_key_name(i), p_key(i));

Line 106: /*EGO_COL_NAME_VALUE_PAIR_ARRAY(

102: LOOP
103: pk_col_value_pairs.extend;
104: pk_col_value_pairs(i) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_key_name(i), p_key(i));
105:
106: /*EGO_COL_NAME_VALUE_PAIR_ARRAY(
107: EGO_COL_NAME_VALUE_PAIR_OBJ(
108: p_key_name, p_key
109: )
110: );*/

Line 128: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2
126: )
127: IS
128: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
129: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
130: l_attribute_group_table PO_TBL_VARCHAR30;
131: BEGIN
132: log_message('COPY_UDAS','Call Get_Attribute_Group_Table');

Line 129: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

125: x_msg_data OUT NOCOPY VARCHAR2
126: )
127: IS
128: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
129: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
130: l_attribute_group_table PO_TBL_VARCHAR30;
131: BEGIN
132: log_message('COPY_UDAS','Call Get_Attribute_Group_Table');
133: l_attribute_group_table := GET_ATTRIBUTE_GROUP_TABLE(attrGroups);

Line 319: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

315: )
316: IS
317: l_errorcode NUMBER;
318: l_template_id NUMBER;
319: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
320: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
321: BEGIN
322: log_message('COPY_LINE_UDAS ','Source '||p_source_auction_header_id||' '||p_source_line_number);
323: log_message('COPY_LINE_UDAS ','Target '||p_target_auction_header_id||' '||p_target_line_number);

Line 320: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

316: IS
317: l_errorcode NUMBER;
318: l_template_id NUMBER;
319: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
320: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
321: BEGIN
322: log_message('COPY_LINE_UDAS ','Source '||p_source_auction_header_id||' '||p_source_line_number);
323: log_message('COPY_LINE_UDAS ','Target '||p_target_auction_header_id||' '||p_target_line_number);
324:

Line 326: EGO_COL_NAME_VALUE_PAIR_ARRAY(

322: log_message('COPY_LINE_UDAS ','Source '||p_source_auction_header_id||' '||p_source_line_number);
323: log_message('COPY_LINE_UDAS ','Target '||p_target_auction_header_id||' '||p_target_line_number);
324:
325: copyfrom_pk_col_value_pairs :=
326: EGO_COL_NAME_VALUE_PAIR_ARRAY(
327: EGO_COL_NAME_VALUE_PAIR_OBJ(
328: g_auc_header_pkey_col, p_source_auction_header_id
329: ),
330: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 336: EGO_COL_NAME_VALUE_PAIR_ARRAY(

332: )
333: );
334:
335: copyto_pk_col_value_pairs :=
336: EGO_COL_NAME_VALUE_PAIR_ARRAY(
337: EGO_COL_NAME_VALUE_PAIR_OBJ(
338: g_auc_header_pkey_col, p_target_auction_header_id
339: ),
340: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 406: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

402: x_msg_data OUT NOCOPY VARCHAR2) IS
403:
404: l_errorcode NUMBER;
405: l_source_template_id NUMBER;
406: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
407: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
408: l_attribute_group_table PO_TBL_VARCHAR30;
409: l_complex_attr_grp VARCHAR2(50);
410:

Line 407: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

403:
404: l_errorcode NUMBER;
405: l_source_template_id NUMBER;
406: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
407: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
408: l_attribute_group_table PO_TBL_VARCHAR30;
409: l_complex_attr_grp VARCHAR2(50);
410:
411: BEGIN

Line 429: EGO_COL_NAME_VALUE_PAIR_ARRAY

425: l_source_template_id := p_auction_template_id;
426: /*insert into vhk_debug_msg values('line_number : '||p_line_number
427: ||' g_auc_header_pkey_col : '||g_auc_header_pkey_col);*/
428: copyfrom_pk_col_value_pairs :=
429: EGO_COL_NAME_VALUE_PAIR_ARRAY
430: (
431: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_header_pkey_col, p_auction_header_id),
432: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_line_number, p_line_number)
433: );

Line 439: EGO_COL_NAME_VALUE_PAIR_ARRAY

435:
436: ELSE
437: l_source_template_id := p_bid_template_id;
438: copyfrom_pk_col_value_pairs :=
439: EGO_COL_NAME_VALUE_PAIR_ARRAY
440: (
441: EGO_COL_NAME_VALUE_PAIR_OBJ(g_bid_number_pkey_col, p_source_bid_number),
442: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_line_number, p_line_number)
443: );

Line 452: EGO_COL_NAME_VALUE_PAIR_ARRAY

448:
449: END IF;
450:
451: copyto_pk_col_value_pairs :=
452: EGO_COL_NAME_VALUE_PAIR_ARRAY
453: (
454: EGO_COL_NAME_VALUE_PAIR_OBJ(g_bid_number_pkey_col, p_bid_number),
455: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_line_number, p_line_number)
456: );

Line 567: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

563: x_return_status OUT NOCOPY VARCHAR2,
564: x_msg_count OUT NOCOPY NUMBER,
565: x_msg_data OUT NOCOPY VARCHAR2) IS
566:
567: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
568: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
569: l_attribute_group_table PO_TBL_VARCHAR30;
570: l_src_pkey PO_TBL_NUMBER;
571: l_tar_pkey PO_TBL_NUMBER;

Line 568: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

564: x_msg_count OUT NOCOPY NUMBER,
565: x_msg_data OUT NOCOPY VARCHAR2) IS
566:
567: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
568: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
569: l_attribute_group_table PO_TBL_VARCHAR30;
570: l_src_pkey PO_TBL_NUMBER;
571: l_tar_pkey PO_TBL_NUMBER;
572: l_excl_addr_types PO_TBL_VARCHAR50;

Line 576: EGO_COL_NAME_VALUE_PAIR_ARRAY

572: l_excl_addr_types PO_TBL_VARCHAR50;
573:
574: BEGIN
575: copyfrom_pk_col_value_pairs :=
576: EGO_COL_NAME_VALUE_PAIR_ARRAY
577: (
578: EGO_COL_NAME_VALUE_PAIR_OBJ(g_req_header_pkey_col, p_req_header_id)
579: );
580:

Line 582: EGO_COL_NAME_VALUE_PAIR_ARRAY

578: EGO_COL_NAME_VALUE_PAIR_OBJ(g_req_header_pkey_col, p_req_header_id)
579: );
580:
581: copyto_pk_col_value_pairs :=
582: EGO_COL_NAME_VALUE_PAIR_ARRAY
583: (
584: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_header_pkey_col, p_auction_header_id)
585: );
586:

Line 754: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

750: x_return_status OUT NOCOPY VARCHAR2,
751: x_msg_count OUT NOCOPY NUMBER,
752: x_msg_data OUT NOCOPY VARCHAR2) IS
753:
754: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
755: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
756: l_attribute_group_table PO_TBL_VARCHAR30;
757: l_src_template_id NUMBER;
758: l_dest_template_id NUMBER;

Line 755: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

751: x_msg_count OUT NOCOPY NUMBER,
752: x_msg_data OUT NOCOPY VARCHAR2) IS
753:
754: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
755: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
756: l_attribute_group_table PO_TBL_VARCHAR30;
757: l_src_template_id NUMBER;
758: l_dest_template_id NUMBER;
759: l_module VARCHAR2(30) := 'COPY_PO_LINE_UDA';

Line 815: EGO_COL_NAME_VALUE_PAIR_ARRAY

811:
812: l_attribute_group_table := GET_ATTRIBUTE_GROUP_TABLE(attrGroups);
813:
814: copyfrom_pk_col_value_pairs :=
815: EGO_COL_NAME_VALUE_PAIR_ARRAY
816: (
817: EGO_COL_NAME_VALUE_PAIR_OBJ(g_po_line_pkey_col, p_po_line_id),
818: EGO_COL_NAME_VALUE_PAIR_OBJ(g_po_draft_pkey_col, -1)
819: );

Line 822: EGO_COL_NAME_VALUE_PAIR_ARRAY

818: EGO_COL_NAME_VALUE_PAIR_OBJ(g_po_draft_pkey_col, -1)
819: );
820:
821: copyto_pk_col_value_pairs :=
822: EGO_COL_NAME_VALUE_PAIR_ARRAY
823: (
824: EGO_COL_NAME_VALUE_PAIR_OBJ(g_bid_number_pkey_col, p_bid_header_id),
825: EGO_COL_NAME_VALUE_PAIR_OBJ(g_auc_line_number, p_bid_line_number)
826: );

Line 906: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS

902:
903: FUNCTION GET_EGO_PKEY_VALUE_PAIR (p_pkey IN PO_TBL_NUMBER,
904: p_doc_level IN VARCHAR2,
905: p_doc_type IN VARCHAR2)
906: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
907: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
908: l_col_name1 VARCHAR2(40);
909: l_col_name2 VARCHAR2(40);
910: BEGIN

Line 907: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

903: FUNCTION GET_EGO_PKEY_VALUE_PAIR (p_pkey IN PO_TBL_NUMBER,
904: p_doc_level IN VARCHAR2,
905: p_doc_type IN VARCHAR2)
906: RETURN EGO_COL_NAME_VALUE_PAIR_ARRAY IS
907: pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
908: l_col_name1 VARCHAR2(40);
909: l_col_name2 VARCHAR2(40);
910: BEGIN
911: if ( p_doc_level = 'HEADER' ) THEN

Line 958: EGO_COL_NAME_VALUE_PAIR_ARRAY (

954: END IF;
955: if ( l_col_name2 is NULL ) THEN
956:
957: pk_col_value_pairs :=
958: EGO_COL_NAME_VALUE_PAIR_ARRAY (
959: EGO_COL_NAME_VALUE_PAIR_OBJ(l_col_name1,p_pkey(1))
960: );
961: else
962:

Line 964: EGO_COL_NAME_VALUE_PAIR_ARRAY (

960: );
961: else
962:
963: pk_col_value_pairs :=
964: EGO_COL_NAME_VALUE_PAIR_ARRAY (
965: EGO_COL_NAME_VALUE_PAIR_OBJ(l_col_name1,p_pkey(1)),
966: EGO_COL_NAME_VALUE_PAIR_OBJ(l_col_name2,p_pkey(2))
967: );
968: end if;

Line 992: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2)
990: IS
991:
992: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
993: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
994: l_attribute_group_table PO_TBL_VARCHAR30;
995: l_cpy_mode VARCHAR2(10);
996:

Line 993: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

989: x_msg_data OUT NOCOPY VARCHAR2)
990: IS
991:
992: copyfrom_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
993: copyto_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
994: l_attribute_group_table PO_TBL_VARCHAR30;
995: l_cpy_mode VARCHAR2(10);
996:
997: BEGIN

Line 1063: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1059: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1060:
1061: l_process_attr_row_tbl EGO_USER_ATTR_ROW_TABLE;
1062: l_process_attr_data_tbl EGO_USER_ATTR_DATA_TABLE;
1063: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1064:
1065:
1066: l_tar_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1067: l_attr_list VARCHAR2(2000);

Line 1072: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1068: l_src_data_level VARCHAR2(100);
1069: l_tar_data_level VARCHAR2(100);
1070: l_src_object_name VARCHAR2(200);
1071: l_tar_object_name VARCHAR2(200);
1072: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1073: l_tar_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1074:
1075:
1076: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

Line 1073: l_tar_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1069: l_tar_data_level VARCHAR2(100);
1070: l_src_object_name VARCHAR2(200);
1071: l_tar_object_name VARCHAR2(200);
1072: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1073: l_tar_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1074:
1075:
1076: x_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1077: x_attributes_data_table EGO_USER_ATTR_DATA_TABLE;

Line 1159: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',p_tar_template_id));

1155: p_doc_type=>p_src_doc_type);
1156: l_tar_pk_col_name_val_pairs := GET_EGO_PKEY_VALUE_PAIR (p_pkey=>p_tar_pkey,
1157: p_doc_level=>'HEADER',
1158: p_doc_type=>'SOL');
1159: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',p_tar_template_id));
1160:
1161:
1162:
1163: