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));
105:
106: /*EGO_COL_NAME_VALUE_PAIR_ARRAY(
107: EGO_COL_NAME_VALUE_PAIR_OBJ(
108: p_key_name, p_key
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: );*/
111: END LOOP;
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(
331: g_auc_line_number, p_source_line_number
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(
331: g_auc_line_number, p_source_line_number
332: )
333: );
334:
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(
341: g_auc_line_number, p_target_line_number
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(
341: g_auc_line_number, p_target_line_number
342: )
343: );
344:
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: );
434:
435:
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: );
434:
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: );
444:
445: IF(l_complex_attr_grp IS NOT NULL) THEN
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: );
444:
445: IF(l_complex_attr_grp IS NOT NULL) THEN
446: l_attribute_group_table := PO_TBL_VARCHAR30 ('ADD_ITEM_INFO','FED_CUST_DESG',l_complex_attr_grp);
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: );
457:
458:
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: );
457:
458:
459:
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:
581: copyto_pk_col_value_pairs :=
582: EGO_COL_NAME_VALUE_PAIR_ARRAY
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:
587: -- 'SET_ASIDE_INFO',,'SF1442_Informa' are not there in req header.
588: --l_attribute_group_table := PO_TBL_VARCHAR30 ('BU_PRI_PRJ_INF');
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: );
820:
821: copyto_pk_col_value_pairs :=
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: );
820:
821: copyto_pk_col_value_pairs :=
822: EGO_COL_NAME_VALUE_PAIR_ARRAY
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: );
827:
828: AUTO_CREATE_UDA_COPY(l_src_template_id
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: );
827:
828: AUTO_CREATE_UDA_COPY(l_src_template_id
829: ,l_dest_template_id
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:
963: pk_col_value_pairs :=
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;
969:
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;
969:
970:
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: