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 PO_TBL_NUMBER

Line 174: p_src_pkey PO_TBL_NUMBER;

170: l_amd_flag VARCHAR2(1);
171: l_prev_hdr_id1 NUMBER;
172: l_prev_hdr_id2 NUMBER;
173:
174: p_src_pkey PO_TBL_NUMBER;
175: p_tar_pkey PO_TBL_NUMBER;
176: l_excl_addr_types PO_TBL_VARCHAR50;
177:
178: cursor addTypCur is

Line 175: p_tar_pkey PO_TBL_NUMBER;

171: l_prev_hdr_id1 NUMBER;
172: l_prev_hdr_id2 NUMBER;
173:
174: p_src_pkey PO_TBL_NUMBER;
175: p_tar_pkey PO_TBL_NUMBER;
176: l_excl_addr_types PO_TBL_VARCHAR50;
177:
178: cursor addTypCur is
179: select lookup_code from po_lookup_codes where lookup_type = 'SOL_AMD_UDA_ADDRESS_TYPES'

Line 220: p_src_pkey := PO_TBL_NUMBER();

216: x_msg_data);
217:
218: log_message('COPY_Header_UDAs','After COPY_UDAs '||x_return_status);
219: --Handle Addresses
220: p_src_pkey := PO_TBL_NUMBER();
221: p_src_pkey.extend(1);
222: p_src_pkey(1) := p_source_auction_header_id;
223:
224: p_tar_pkey := PO_TBL_NUMBER();

Line 224: p_tar_pkey := PO_TBL_NUMBER();

220: p_src_pkey := PO_TBL_NUMBER();
221: p_src_pkey.extend(1);
222: p_src_pkey(1) := p_source_auction_header_id;
223:
224: p_tar_pkey := PO_TBL_NUMBER();
225: p_tar_pkey.extend(1);
226: p_tar_pkey(1) := p_target_auction_header_id;
227:
228:

Line 570: l_src_pkey PO_TBL_NUMBER;

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:
574: BEGIN

Line 571: l_tar_pkey PO_TBL_NUMBER;

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:
574: BEGIN
575: copyfrom_pk_col_value_pairs :=

Line 610: l_src_pkey := PO_TBL_NUMBER();

606:
607:
608: IF ( x_return_status = 'S' ) Then
609:
610: l_src_pkey := PO_TBL_NUMBER();
611: l_src_pkey.extend(1);
612: l_src_pkey(1) := p_req_header_id;
613:
614: l_tar_pkey := PO_TBL_NUMBER();

Line 614: l_tar_pkey := PO_TBL_NUMBER();

610: l_src_pkey := PO_TBL_NUMBER();
611: l_src_pkey.extend(1);
612: l_src_pkey(1) := p_req_header_id;
613:
614: l_tar_pkey := PO_TBL_NUMBER();
615: l_tar_pkey.extend(1);
616: l_tar_pkey(1) := p_auction_header_id;
617:
618: l_excl_addr_types := PO_TBL_VARCHAR50();

Line 685: l_src_pkey PO_TBL_NUMBER;

681: x_msg_data OUT NOCOPY VARCHAR2) IS
682:
683:
684:
685: l_src_pkey PO_TBL_NUMBER;
686: l_tar_pkey PO_TBL_NUMBER;
687:
688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;
689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;

Line 686: l_tar_pkey PO_TBL_NUMBER;

682:
683:
684:
685: l_src_pkey PO_TBL_NUMBER;
686: l_tar_pkey PO_TBL_NUMBER;
687:
688: l_cost_constraint pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE;
689: l_idc_type pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE;
690: l_contract_type pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE;

Line 699: l_src_pkey := PO_TBL_NUMBER();

695: where auction_header_id=p_auction_header_id
696: and line_number=p_auction_line_number;
697:
698:
699: l_src_pkey := PO_TBL_NUMBER();
700: l_src_pkey.extend(1);
701: l_src_pkey(1) := p_req_line_id;
702:
703: l_tar_pkey := PO_TBL_NUMBER();

Line 703: l_tar_pkey := PO_TBL_NUMBER();

699: l_src_pkey := PO_TBL_NUMBER();
700: l_src_pkey.extend(1);
701: l_src_pkey(1) := p_req_line_id;
702:
703: l_tar_pkey := PO_TBL_NUMBER();
704: l_tar_pkey.extend(2);
705: l_tar_pkey(1) := p_auction_header_id;
706: l_tar_pkey(2) := p_auction_line_number;
707:

Line 903: FUNCTION GET_EGO_PKEY_VALUE_PAIR (p_pkey IN PO_TBL_NUMBER,

899:
900:
901:
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;

Line 979: PROCEDURE COPY_UDA_DATA(p_src_pkey IN PO_TBL_NUMBER,

975:
976:
977:
978:
979: PROCEDURE COPY_UDA_DATA(p_src_pkey IN PO_TBL_NUMBER,
980: p_tar_pkey IN PO_TBL_NUMBER,
981: p_src_template_id IN NUMBER,
982: p_tar_template_id IN NUMBER,
983: p_src_doc_level IN VARCHAR2,

Line 980: p_tar_pkey IN PO_TBL_NUMBER,

976:
977:
978:
979: PROCEDURE COPY_UDA_DATA(p_src_pkey IN PO_TBL_NUMBER,
980: p_tar_pkey IN PO_TBL_NUMBER,
981: p_src_template_id IN NUMBER,
982: p_tar_template_id IN NUMBER,
983: p_src_doc_level IN VARCHAR2,
984: p_tar_doc_level IN VARCHAR2,

Line 1043: PROCEDURE PROCESS_ADDRESSES(p_src_pkey IN PO_TBL_NUMBER,

1039: -- Method to copy Address Attribute Group Data
1040: -- Addresses are not handled by UDA API
1041: -- Invoke EGO API directly to get the data
1042: -- And insert into the extension table with new extension Id and primary keys
1043: PROCEDURE PROCESS_ADDRESSES(p_src_pkey IN PO_TBL_NUMBER,
1044: p_tar_pkey IN PO_TBL_NUMBER,
1045: p_src_template_id IN NUMBER,
1046: p_tar_template_id IN NUMBER,
1047: p_src_doc_type IN VARCHAR2,

Line 1044: p_tar_pkey IN PO_TBL_NUMBER,

1040: -- Addresses are not handled by UDA API
1041: -- Invoke EGO API directly to get the data
1042: -- And insert into the extension table with new extension Id and primary keys
1043: PROCEDURE PROCESS_ADDRESSES(p_src_pkey IN PO_TBL_NUMBER,
1044: p_tar_pkey IN PO_TBL_NUMBER,
1045: p_src_template_id IN NUMBER,
1046: p_tar_template_id IN NUMBER,
1047: p_src_doc_type IN VARCHAR2,
1048: p_excl_addr_types IN PO_TBL_VARCHAR50,

Line 1094: l_extn_id_list PO_TBL_NUMBER;

1090:
1091: Type addr_extn_type IS REF Cursor;
1092: addrExtnCur addr_extn_type;
1093:
1094: l_extn_id_list PO_TBL_NUMBER;
1095:
1096: Begin
1097:
1098: IF ( p_src_doc_type = 'SOL' ) THEN