DBA Data[Home] [Help]

APPS.PON_COPY_UDAS_GRP dependencies on PO_TBL_VARCHAR50

Line 176: l_excl_addr_types PO_TBL_VARCHAR50;

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'
180: MINUS

Line 572: l_excl_addr_types PO_TBL_VARCHAR50;

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 :=
576: EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 618: l_excl_addr_types := PO_TBL_VARCHAR50();

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();
619:
620: log_message('COPY_REQ_HEADER_UDA','Call process_addresses ');
621: process_addresses(p_src_pkey=>l_src_pkey
622: ,p_tar_pkey=>l_tar_pkey

Line 1048: p_excl_addr_types IN PO_TBL_VARCHAR50,

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,
1049: x_return_status OUT NOCOPY VARCHAR2,
1050: x_msg_count OUT NOCOPY NUMBER,
1051: x_msg_data OUT NOCOPY VARCHAR2)
1052: IS