[Home] [Help]
1557: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1558: l_itm_row_id VARCHAR2 (25);
1559: l_fmnt_row_id VARCHAR2 (25);
1560: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1561: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
1562: l_return_status VARCHAR2 (30);
1563: l_msg_data VARCHAR2 (1000);
1564: l_msg_count NUMBER;
1565: BEGIN
1771: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1772: l_itm_row_id VARCHAR2 (25);
1773: l_fmnt_row_id VARCHAR2 (25);
1774: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1775: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
1776: l_return_status VARCHAR2 (30);
1777: l_msg_data VARCHAR2 (1000);
1778: l_msg_count NUMBER;
1779: BEGIN
2751: l_item_number igs_as_doc_details.item_number%TYPE;
2752: l_programs_on_file igs_as_doc_details.programs_on_file%TYPE;
2753: l_printer_options_ret BOOLEAN;
2754: l_req_id NUMBER;
2755: l_oss_country_cd VARCHAR2 (10) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
2756: l_rep_name VARCHAR2 (10);
2757: l_message VARCHAR2 (2000);
2758: BEGIN
2759: l_printer_options_ret :=
2830: AND item_number IN (cp_item_numbers);
2831: l_encert NUMBER (1) := 0;
2832: l_trns NUMBER (1) := 0;
2833: BEGIN
2834: l_oss_country_cd := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
2835: -- verify the type of doc
2836: OPEN v FOR encert;
2837: LOOP
2838: FETCH v INTO l_encert;
2997: BEGIN
2998:
2999: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
3000:
3001: l_oss_country_cd := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
3002: l_person_ids := p_person_ids;
3003: l_program_cds := p_program_cds;
3004: l_prog_vers := p_prog_vers;
3005: -- Admin Person address information for order header table