[Home] [Help]
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
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2)
75: );
76:
77: END;
78:
79: FUNCTION GET_ATTRIBUTE_GROUP_TABLE(attrGroups AttrGroupList) RETURN PO_TBL_VARCHAR30
80: IS
81: l_attribute_group_table PO_TBL_VARCHAR30;
82: BEGIN
83: l_attribute_group_table := PO_TBL_VARCHAR30();
77: END;
78:
79: FUNCTION GET_ATTRIBUTE_GROUP_TABLE(attrGroups AttrGroupList) RETURN PO_TBL_VARCHAR30
80: IS
81: l_attribute_group_table PO_TBL_VARCHAR30;
82: BEGIN
83: l_attribute_group_table := PO_TBL_VARCHAR30();
84: log_message('get_attribute_group_table ','Entered method '||attrGroups.COUNT);
85: for i in attrGroups.FIRST .. attrGroups.LAST
79: FUNCTION GET_ATTRIBUTE_GROUP_TABLE(attrGroups AttrGroupList) RETURN PO_TBL_VARCHAR30
80: IS
81: l_attribute_group_table PO_TBL_VARCHAR30;
82: BEGIN
83: l_attribute_group_table := PO_TBL_VARCHAR30();
84: log_message('get_attribute_group_table ','Entered method '||attrGroups.COUNT);
85: for i in attrGroups.FIRST .. attrGroups.LAST
86: LOOP
87: l_attribute_group_table.extend;
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);
134: log_message('COPY_UDAS','Return Get_Attribute_Group_table');
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
412:
417:
418:
419: l_complex_attr_grp := get_complex_attr_grp_name (p_bid_number,p_line_number,p_bid_template_id );
420:
421: l_attribute_group_table := PO_TBL_VARCHAR30 ('ADD_ITEM_INFO','FED_CUST_DESG');
422:
423: IF p_copyfrom = 'A' THEN
424:
425: l_source_template_id := p_auction_template_id;
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);
447: END IF;
448:
449: END IF;
450:
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;
573:
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');
589: get_attribute_groups(p_uda_template_id => p_src_template_id
590: ,x_attr_group_tbl => l_attribute_group_table);
591:
592: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
634:
635: END COPY_REQ_HEADER_UDA;
636:
637: PROCEDURE get_attribute_groups(p_uda_template_id IN NUMBER,
638: x_attr_group_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
639: )
640: IS
641: l_api_name VARCHAR2(30) := 'get_attribute_groups';
642: l_progress VARCHAR2(3) := '000';
643:
644:
645: l_return_status VARCHAR2(1);
646: l_err_msg VARCHAR2(1000);
647: l_attr_group_tbl PO_TBL_VARCHAR30;
648:
649: BEGIN
650:
651: l_progress := '010';
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';
760: attrGroups AttrGroupList;
857: p_src_doc_type IN VARCHAR2,
858: p_tar_doc_type IN VARCHAR2,
859: p_src_template_id IN NUMBER,
860: p_tar_template_id IN NUMBER)
861: RETURN PO_TBL_VARCHAR30 IS
862: TYPE agCurType IS REF CURSOR;
863: attrGrpCur agCurType;
864: l_attr_grp_list PO_TBL_VARCHAR30;
865: BEGIN
860: p_tar_template_id IN NUMBER)
861: RETURN PO_TBL_VARCHAR30 IS
862: TYPE agCurType IS REF CURSOR;
863: attrGrpCur agCurType;
864: l_attr_grp_list PO_TBL_VARCHAR30;
865: BEGIN
866: attrGrpCur := NULL;
867: if ( p_src_doc_type = 'PO' ) THEN
868: if ( p_tar_doc_level = 'HEADER' ) THEN
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
998: