DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on WF_ITEMS

Line 14959: l_item_type wf_items.item_type%TYPE;

14955:
14956: NL VARCHAR2(1) := fnd_global.newline;
14957: l_document VARCHAR2(32000) := '';
14958: l_disp_type VARCHAR2(20) := 'text/plain';
14959: l_item_type wf_items.item_type%TYPE;
14960: l_item_key wf_items.item_key%TYPE;
14961: x_preview_date DATE;
14962: x_preview_date_notspec VARCHAR2(240);
14963: x_auction_start_date DATE;

Line 14960: l_item_key wf_items.item_key%TYPE;

14956: NL VARCHAR2(1) := fnd_global.newline;
14957: l_document VARCHAR2(32000) := '';
14958: l_disp_type VARCHAR2(20) := 'text/plain';
14959: l_item_type wf_items.item_type%TYPE;
14960: l_item_key wf_items.item_key%TYPE;
14961: x_preview_date DATE;
14962: x_preview_date_notspec VARCHAR2(240);
14963: x_auction_start_date DATE;
14964: x_auction_end_date DATE;

Line 15164: l_item_type wf_items.item_type%TYPE;

15160:
15161: NL VARCHAR2(1) := fnd_global.newline;
15162: l_document VARCHAR2(32000) := '';
15163: l_disp_type VARCHAR2(20) := 'text/plain';
15164: l_item_type wf_items.item_type%TYPE;
15165: l_item_key wf_items.item_key%TYPE;
15166: x_preview_date DATE;
15167: x_preview_date_notspec VARCHAR2(240);
15168: x_auction_start_date DATE;

Line 15165: l_item_key wf_items.item_key%TYPE;

15161: NL VARCHAR2(1) := fnd_global.newline;
15162: l_document VARCHAR2(32000) := '';
15163: l_disp_type VARCHAR2(20) := 'text/plain';
15164: l_item_type wf_items.item_type%TYPE;
15165: l_item_key wf_items.item_key%TYPE;
15166: x_preview_date DATE;
15167: x_preview_date_notspec VARCHAR2(240);
15168: x_auction_start_date DATE;
15169: x_auction_end_date DATE;

Line 15327: l_item_type wf_items.item_type%TYPE;

15323:
15324: NL VARCHAR2(1) := fnd_global.newline;
15325: l_document VARCHAR2(32000) := '';
15326: l_disp_type VARCHAR2(20) := 'text/plain';
15327: l_item_type wf_items.item_type%TYPE;
15328: l_item_key wf_items.item_key%TYPE;
15329: x_preview_date DATE;
15330: x_preview_date_notspec VARCHAR2(240);
15331: x_auction_start_date DATE;

Line 15328: l_item_key wf_items.item_key%TYPE;

15324: NL VARCHAR2(1) := fnd_global.newline;
15325: l_document VARCHAR2(32000) := '';
15326: l_disp_type VARCHAR2(20) := 'text/plain';
15327: l_item_type wf_items.item_type%TYPE;
15328: l_item_key wf_items.item_key%TYPE;
15329: x_preview_date DATE;
15330: x_preview_date_notspec VARCHAR2(240);
15331: x_auction_start_date DATE;
15332: x_auction_end_date DATE;

Line 15545: l_item_type wf_items.item_type%TYPE;

15541:
15542: NL VARCHAR2(1) := fnd_global.newline;
15543: l_document VARCHAR2(32000) := '';
15544: l_disp_type VARCHAR2(20) := 'text/plain';
15545: l_item_type wf_items.item_type%TYPE;
15546: l_item_key wf_items.item_key%TYPE;
15547: x_preview_date DATE;
15548: x_preview_date_notspec VARCHAR2(240);
15549: x_auction_start_date DATE;

Line 15546: l_item_key wf_items.item_key%TYPE;

15542: NL VARCHAR2(1) := fnd_global.newline;
15543: l_document VARCHAR2(32000) := '';
15544: l_disp_type VARCHAR2(20) := 'text/plain';
15545: l_item_type wf_items.item_type%TYPE;
15546: l_item_key wf_items.item_key%TYPE;
15547: x_preview_date DATE;
15548: x_preview_date_notspec VARCHAR2(240);
15549: x_auction_start_date DATE;
15550: x_auction_end_date DATE;

Line 15754: l_item_type wf_items.item_type%TYPE;

15750:
15751: NL VARCHAR2(1) := fnd_global.newline;
15752: l_document VARCHAR2(32000) := '';
15753: l_disp_type VARCHAR2(20) := 'text/plain';
15754: l_item_type wf_items.item_type%TYPE;
15755: l_item_key wf_items.item_key%TYPE;
15756: x_preview_date DATE;
15757: x_preview_date_notspec VARCHAR2(240);
15758: x_auction_start_date DATE;

Line 15755: l_item_key wf_items.item_key%TYPE;

15751: NL VARCHAR2(1) := fnd_global.newline;
15752: l_document VARCHAR2(32000) := '';
15753: l_disp_type VARCHAR2(20) := 'text/plain';
15754: l_item_type wf_items.item_type%TYPE;
15755: l_item_key wf_items.item_key%TYPE;
15756: x_preview_date DATE;
15757: x_preview_date_notspec VARCHAR2(240);
15758: x_auction_start_date DATE;
15759: x_auction_end_date DATE;

Line 15985: l_item_type wf_items.item_type%TYPE;

15981:
15982: NL VARCHAR2(1) := fnd_global.newline;
15983: l_document VARCHAR2(32000) := '';
15984: l_disp_type VARCHAR2(20) := 'text/plain';
15985: l_item_type wf_items.item_type%TYPE;
15986: l_item_key wf_items.item_key%TYPE;
15987: x_preview_date DATE;
15988: x_preview_date_notspec VARCHAR2(240);
15989: x_auction_start_date DATE;

Line 15986: l_item_key wf_items.item_key%TYPE;

15982: NL VARCHAR2(1) := fnd_global.newline;
15983: l_document VARCHAR2(32000) := '';
15984: l_disp_type VARCHAR2(20) := 'text/plain';
15985: l_item_type wf_items.item_type%TYPE;
15986: l_item_key wf_items.item_key%TYPE;
15987: x_preview_date DATE;
15988: x_preview_date_notspec VARCHAR2(240);
15989: x_auction_start_date DATE;
15990: x_auction_end_date DATE;

Line 16195: l_item_type wf_items.item_type%TYPE;

16191:
16192: NL VARCHAR2(1) := fnd_global.newline;
16193: l_document VARCHAR2(32000) := '';
16194: l_disp_type VARCHAR2(20) := 'text/plain';
16195: l_item_type wf_items.item_type%TYPE;
16196: l_item_key wf_items.item_key%TYPE;
16197: x_auction_start_date DATE;
16198: x_auction_end_date DATE;
16199: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

Line 16196: l_item_key wf_items.item_key%TYPE;

16192: NL VARCHAR2(1) := fnd_global.newline;
16193: l_document VARCHAR2(32000) := '';
16194: l_disp_type VARCHAR2(20) := 'text/plain';
16195: l_item_type wf_items.item_type%TYPE;
16196: l_item_key wf_items.item_key%TYPE;
16197: x_auction_start_date DATE;
16198: x_auction_end_date DATE;
16199: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16200: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;

Line 16344: l_item_type wf_items.item_type%TYPE;

16340:
16341: NL VARCHAR2(1) := fnd_global.newline;
16342: l_document VARCHAR2(32000) := '';
16343: l_disp_type VARCHAR2(20) := 'text/plain';
16344: l_item_type wf_items.item_type%TYPE;
16345: l_item_key wf_items.item_key%TYPE;
16346: x_preview_date DATE;
16347: x_preview_date_notspec VARCHAR2(240);
16348: x_auction_start_date DATE;

Line 16345: l_item_key wf_items.item_key%TYPE;

16341: NL VARCHAR2(1) := fnd_global.newline;
16342: l_document VARCHAR2(32000) := '';
16343: l_disp_type VARCHAR2(20) := 'text/plain';
16344: l_item_type wf_items.item_type%TYPE;
16345: l_item_key wf_items.item_key%TYPE;
16346: x_preview_date DATE;
16347: x_preview_date_notspec VARCHAR2(240);
16348: x_auction_start_date DATE;
16349: x_auction_end_date DATE;

Line 16583: l_item_type wf_items.item_type%TYPE;

16579:
16580: NL VARCHAR2(1) := fnd_global.newline;
16581: l_document VARCHAR2(32000) := '';
16582: l_disp_type VARCHAR2(20) := 'text/plain';
16583: l_item_type wf_items.item_type%TYPE;
16584: l_item_key wf_items.item_key%TYPE;
16585: x_preview_date DATE;
16586: x_preview_date_notspec VARCHAR2(240);
16587: x_auction_start_date DATE;

Line 16584: l_item_key wf_items.item_key%TYPE;

16580: NL VARCHAR2(1) := fnd_global.newline;
16581: l_document VARCHAR2(32000) := '';
16582: l_disp_type VARCHAR2(20) := 'text/plain';
16583: l_item_type wf_items.item_type%TYPE;
16584: l_item_key wf_items.item_key%TYPE;
16585: x_preview_date DATE;
16586: x_preview_date_notspec VARCHAR2(240);
16587: x_auction_start_date DATE;
16588: x_auction_end_date DATE;

Line 16767: l_item_type wf_items.item_type%TYPE;

16763:
16764: NL VARCHAR2(1) := fnd_global.newline;
16765: l_document VARCHAR2(32000) := '';
16766: l_disp_type VARCHAR2(20) := 'text/plain';
16767: l_item_type wf_items.item_type%TYPE;
16768: l_item_key wf_items.item_key%TYPE;
16769: x_preview_date DATE;
16770: x_preview_date_notspec VARCHAR2(240);
16771: x_auction_start_date DATE;

Line 16768: l_item_key wf_items.item_key%TYPE;

16764: NL VARCHAR2(1) := fnd_global.newline;
16765: l_document VARCHAR2(32000) := '';
16766: l_disp_type VARCHAR2(20) := 'text/plain';
16767: l_item_type wf_items.item_type%TYPE;
16768: l_item_key wf_items.item_key%TYPE;
16769: x_preview_date DATE;
16770: x_preview_date_notspec VARCHAR2(240);
16771: x_auction_start_date DATE;
16772: x_auction_end_date DATE;

Line 16966: l_item_type wf_items.item_type%TYPE;

16962:
16963: NL VARCHAR2(1) := fnd_global.newline;
16964: l_document VARCHAR2(32000) := '';
16965: l_disp_type VARCHAR2(20) := 'text/plain';
16966: l_item_type wf_items.item_type%TYPE;
16967: l_item_key wf_items.item_key%TYPE;
16968: x_preview_date DATE;
16969: x_preview_date_notspec VARCHAR2(240);
16970: x_auction_start_date DATE;

Line 16967: l_item_key wf_items.item_key%TYPE;

16963: NL VARCHAR2(1) := fnd_global.newline;
16964: l_document VARCHAR2(32000) := '';
16965: l_disp_type VARCHAR2(20) := 'text/plain';
16966: l_item_type wf_items.item_type%TYPE;
16967: l_item_key wf_items.item_key%TYPE;
16968: x_preview_date DATE;
16969: x_preview_date_notspec VARCHAR2(240);
16970: x_auction_start_date DATE;
16971: x_auction_end_date DATE;

Line 17148: l_item_type wf_items.item_type%TYPE;

17144:
17145: NL VARCHAR2(1) := fnd_global.newline;
17146: l_document VARCHAR2(32000) := '';
17147: l_disp_type VARCHAR2(20) := 'text/plain';
17148: l_item_type wf_items.item_type%TYPE;
17149: l_item_key wf_items.item_key%TYPE;
17150: x_preview_date DATE;
17151: x_preview_date_notspec VARCHAR2(240);
17152: x_auction_start_date DATE;

Line 17149: l_item_key wf_items.item_key%TYPE;

17145: NL VARCHAR2(1) := fnd_global.newline;
17146: l_document VARCHAR2(32000) := '';
17147: l_disp_type VARCHAR2(20) := 'text/plain';
17148: l_item_type wf_items.item_type%TYPE;
17149: l_item_key wf_items.item_key%TYPE;
17150: x_preview_date DATE;
17151: x_preview_date_notspec VARCHAR2(240);
17152: x_auction_start_date DATE;
17153: x_auction_end_date DATE;

Line 17578: l_item_type wf_items.item_type%TYPE;

17574: document_type IN OUT NOCOPY VARCHAR2)
17575: IS
17576:
17577: l_document VARCHAR2(32000) := '';
17578: l_item_type wf_items.item_type%TYPE;
17579: l_item_key wf_items.item_key%TYPE;
17580:
17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17582: l_doc_number pon_auction_headers_all.document_number%TYPE;

Line 17579: l_item_key wf_items.item_key%TYPE;

17575: IS
17576:
17577: l_document VARCHAR2(32000) := '';
17578: l_item_type wf_items.item_type%TYPE;
17579: l_item_key wf_items.item_key%TYPE;
17580:
17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17582: l_doc_number pon_auction_headers_all.document_number%TYPE;
17583: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;

Line 17659: l_item_type wf_items.item_type%TYPE;

17655: document_type IN OUT NOCOPY VARCHAR2)
17656: IS
17657:
17658: l_document VARCHAR2(32000) := '';
17659: l_item_type wf_items.item_type%TYPE;
17660: l_item_key wf_items.item_key%TYPE;
17661:
17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17663: l_doc_number pon_auction_headers_all.document_number%TYPE;

Line 17660: l_item_key wf_items.item_key%TYPE;

17656: IS
17657:
17658: l_document VARCHAR2(32000) := '';
17659: l_item_type wf_items.item_type%TYPE;
17660: l_item_key wf_items.item_key%TYPE;
17661:
17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17663: l_doc_number pon_auction_headers_all.document_number%TYPE;
17664: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;