[Home] [Help]
955: NULL,
956: NULL,
957: NULL,
958: 'ICX_HEADER',
959: --fnd_message.get_String('PO', 'POS_NO_DIFFERENCE'),
960: 'ICX_NO_DIFFERENCE',
961: NULL,
962: NULL
963: );
1094: c_line_num,
1095: c_location_num,
1096: c_distribution_num,
1097: c_level_altered,
1098: --fnd_message.get_String('POS', 'POS_ERROR'),
1099: 'ICX_ERROR',
1100: NULL,
1101: NULL
1102: );
1135: c_line_num,
1136: c_location_num,
1137: c_distribution_num,
1138: c_level_altered,
1139: --fnd_message.get_string('POS', 'POS_CANCELLED'),
1140: 'ICX_CANCELLED',
1141: NULL,
1142: NULL
1143: );
1165: c_line_num,
1166: c_location_num,
1167: c_distribution_num,
1168: c_level_altered,
1169: --fnd_message.get_String('POS', 'POS_BUYER'),
1170: 'ICX_BUYER',
1171: get_buyer( p_po_from.agent_id ),
1172: get_buyer( p_po_to.agent_id )
1173: );
1191: c_line_num,
1192: c_location_num,
1193: c_distribution_num,
1194: c_level_altered,
1195: --fnd_message.get_String('POS', 'POS_SUPPLIER_CONTACT'),
1196: 'ICX_SUPPLIER_CONTACT',
1197: get_vendor_contact( p_po_from.vendor_contact_id ),
1198: get_vendor_contact( p_po_to.vendor_contact_id )
1199: );
1217: c_line_num,
1218: c_location_num,
1219: c_distribution_num,
1220: c_level_altered,
1221: --fnd_message.get_String('POS', 'POS_CONFIRMED'),
1222: 'ICX_CONFIRMED',
1223: p_po_from.confirming_order_flag,
1224: p_po_to.confirming_order_flag
1225: );
1243: c_line_num,
1244: c_location_num,
1245: c_distribution_num,
1246: c_level_altered,
1247: --fnd_message.get_String('POS', 'POS_SHIP_TO'),
1248: 'ICX_SHIP_TO',
1249: get_location( p_po_from.ship_to_location_id ),
1250: get_location( p_po_to.ship_to_location_id )
1251: );
1269: c_line_num,
1270: c_location_num,
1271: c_distribution_num,
1272: c_level_altered,
1273: --fnd_message.get_String('PO', 'POS_BILL_TO'),
1274: 'ICX_BILL_TO',
1275: get_location( p_po_from.bill_to_location_id ),
1276: get_location( p_po_to.bill_to_location_id )
1277: );
1294: c_line_num,
1295: c_location_num,
1296: c_distribution_num,
1297: c_level_altered,
1298: --fnd_message.get_String('PO', 'POS_PAYMENT_TERMS'),
1299: 'ICX_PAYMENT_TERMS',
1300: get_ap_terms( p_po_from.terms_id ),
1301: get_ap_terms( p_po_to.terms_id )
1302: );
1339: c_line_num,
1340: c_location_num,
1341: c_distribution_num,
1342: c_level_altered,
1343: --fnd_message.get_String('PO', 'POS_AMOUNT'),
1344: 'ICX_AMOUNT',
1345: v_amount_from,
1346: v_amount_to
1347: );
1367: c_line_num,
1368: c_location_num,
1369: c_distribution_num,
1370: c_level_altered,
1371: --fnd_message.get_String('PO', 'POS_SHIP_VIA'),
1372: 'ICX_SHIP_VIA',
1373: p_po_from.ship_via_lookup_code,
1374: p_po_to.ship_via_lookup_code
1375: );
1393: c_line_num,
1394: c_location_num,
1395: c_distribution_num,
1396: c_level_altered,
1397: --fnd_message.get_String('PO', 'POS_FOB'),
1398: 'ICX_FOB',
1399: get_po_lookup( 'FOB', p_po_from.fob_lookup_code ),
1400: get_po_lookup( 'FOB', p_po_to.fob_lookup_code )
1401: );
1419: c_line_num,
1420: c_location_num,
1421: c_distribution_num,
1422: c_level_altered,
1423: --fnd_message.get_String('PO', 'POS_FREIGHT_TERMS'),
1424: 'ICX_FREIGHT_TERMS',
1425: get_po_lookup(
1426: 'FREIGHT TERMS',
1427: p_po_from.freight_terms_lookup_code ),
1449: c_line_num,
1450: c_location_num,
1451: c_distribution_num,
1452: c_level_altered,
1453: --fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
1454: 'ICX_NOTE_TO_VENDOR',
1455: p_po_from.note_to_vendor,
1456: p_po_to.note_to_vendor
1457: );
1475: c_line_num,
1476: c_location_num,
1477: c_distribution_num,
1478: c_level_altered,
1479: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
1480: 'ICX_ACCEPTANCE_REQUIRED',
1481: p_po_from.acceptance_required_flag,
1482: p_po_to.acceptance_required_flag
1483: );
1503: c_line_num,
1504: c_location_num,
1505: c_distribution_num,
1506: c_level_altered,
1507: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1508: 'ICX_ACCEPTANCE_DUE_DATE',
1509: --start bug 4179194
1510: /* to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1511: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1539: c_line_num,
1540: c_location_num,
1541: c_distribution_num,
1542: c_level_altered,
1543: --fnd_message.get_String('PO', 'POS_AMOUNT_LIMIT'),
1544: 'ICX_AMOUNT_LIMIT',
1545: p_po_from.amount_limit,
1546: p_po_to.amount_limit
1547: );
1566: c_line_num,
1567: c_location_num,
1568: c_distribution_num,
1569: c_level_altered,
1570: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1571: 'ICX_START_DATE',
1572: --start bug 4179194
1573: /* to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1574: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1605: c_line_num,
1606: c_location_num,
1607: c_distribution_num,
1608: c_level_altered,
1609: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1610: 'ICX_EXPIRATION_DATE',
1611: --start bug 4179194
1612: /* to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1613: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1641: c_line_num,
1642: c_location_num,
1643: c_distribution_num,
1644: c_level_altered,
1645: --fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
1646: 'ICX_AMOUNT_AGREED',
1647: p_po_from.blanket_total_amount,
1648: p_po_to.blanket_total_amount
1649: );
1901: c_line_num,
1902: c_location_num,
1903: c_distribution_num,
1904: c_level_altered,
1905: --fnd_message.get_String('PO', 'POS_NEW'),
1906: 'ICX_NEW',
1907: NULL,
1908: NULL
1909: );
1950: c_line_num,
1951: c_location_num,
1952: c_distribution_num,
1953: c_level_altered,
1954: --fnd_message.get_string('PO', 'POS_CANCELLED'),
1955: 'ICX_CANCELLED',
1956: NULL,
1957: NULL
1958: );
1977: c_line_num,
1978: c_location_num,
1979: c_distribution_num,
1980: c_level_altered,
1981: --fnd_message.get_String('PO', 'POS_BUYER'),
1982: 'ICX_BUYER',
1983: get_buyer( p_release_from.agent_id ),
1984: get_buyer( p_release_to.agent_id )
1985: );
2009: c_line_num,
2010: c_location_num,
2011: c_distribution_num,
2012: c_level_altered,
2013: --fnd_message.get_String('PO', 'POS_AMOUNT'),
2014: 'ICX_AMOUNT',
2015: v_amount_from,
2016: v_amount_to
2017: );
2037: c_line_num,
2038: c_location_num,
2039: c_distribution_num,
2040: c_level_altered,
2041: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
2042: 'ICX_ACCEPTANCE_DUE_DATE',
2043: --start bug 4179194
2044: /* to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2045: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2073: c_line_num,
2074: c_location_num,
2075: c_distribution_num,
2076: c_level_altered,
2077: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
2078: 'ICX_ACCEPTANCE_REQUIRED',
2079: p_release_from.acceptance_required_flag,
2080: p_release_to.acceptance_required_flag
2081: );
2099: c_line_num,
2100: c_location_num,
2101: c_distribution_num,
2102: c_level_altered,
2103: --fnd_message.get_String('PO', 'POS_RELEASE_NUMBER'),
2104: 'ICX_RELEASE_NUMBER',
2105: p_release_from.release_num,
2106: p_release_to.release_num
2107: );
2127: c_line_num,
2128: c_location_num,
2129: c_distribution_num,
2130: c_level_altered,
2131: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
2132: 'ICX_RELEASE_DATE',
2133: --start bug 4179194
2134: /* to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2135: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2768: c_line_num,
2769: c_location_num,
2770: c_distribution_num,
2771: c_level_altered,
2772: --fnd_message.get_string('PO', 'POS_CANCELLED'),
2773: 'ICX_CANCELLED',
2774: NULL,
2775: NULL,
2776: NULL,
2807: c_line_num,
2808: c_location_num,
2809: c_distribution_num,
2810: c_level_altered,
2811: --fnd_message.get_String('PO', 'POS_UNIT_PRICE'),
2812: 'ICX_UNIT_PRICE',
2813: p_line_from.unit_price,
2814: p_line_to.unit_price,
2815: NULL,
2839: c_line_num,
2840: c_location_num,
2841: c_distribution_num,
2842: c_level_altered,
2843: --fnd_message.get_String('PO', 'POS_LINE_NUMBER'),
2844: 'ICX_LINE_NUMBER',
2845: p_line_from.line_num,
2846: p_line_to.line_num,
2847: NULL,
2871: c_line_num,
2872: c_location_num,
2873: c_distribution_num,
2874: c_level_altered,
2875: --fnd_message.get_String('PO', 'POS_ITEM'),
2876: 'ICX_ITEM',
2877: -- get_item_number( p_line_from.item_id ),
2878: -- get_item_number( p_line_to.item_id ),
2879: get_item( p_line_from.item_id, p_line_from.org_id ),
2905: c_line_num,
2906: c_location_num,
2907: c_distribution_num,
2908: c_level_altered,
2909: --fnd_message.get_String('PO', 'POS_ITEM'),
2910: 'ICX_JOB',
2911: get_job( p_line_from.job_id),
2912: get_job( p_line_to.job_id),
2913: NULL,
2968: c_line_num,
2969: c_location_num,
2970: c_distribution_num,
2971: c_level_altered,
2972: --fnd_message.get_String('PO', 'POS_ITEM_REVISION'),
2973: 'ICX_ITEM_REVISION',
2974: p_line_from.item_revision,
2975: p_line_to.item_revision,
2976: NULL,
3000: c_line_num,
3001: c_location_num,
3002: c_distribution_num,
3003: c_level_altered,
3004: --fnd_message.get_String('PO', 'POS_ITEM_DESCRIPTION'),
3005: 'ICX_ITEM_DESCRIPTION',
3006: p_line_from.item_description,
3007: p_line_to.item_description,
3008: NULL,
3032: c_line_num,
3033: c_location_num,
3034: c_distribution_num,
3035: c_level_altered,
3036: --fnd_message.get_String('PO', 'POS_QUANTITY'),
3037: 'ICX_QUANTITY',
3038: p_line_from.quantity,
3039: p_line_to.quantity,
3040: NULL,
3064: c_line_num,
3065: c_location_num,
3066: c_distribution_num,
3067: c_level_altered,
3068: --fnd_message.get_String('PO', 'POS_UOM'),
3069: 'ICX_UOM',
3070: p_line_from.unit_meas_lookup_code,
3071: p_line_to.unit_meas_lookup_code,
3072: NULL,
3096: c_line_num,
3097: c_location_num,
3098: c_distribution_num,
3099: c_level_altered,
3100: --fnd_message.get_String('PO', 'POS_SOURCE_QT_HEADER'),
3101: 'ICX_SOURCE_QT_HEADER',
3102: get_source_quotation_header(
3103: p_line_from.from_header_id ),
3104: get_source_quotation_header(
3130: c_line_num,
3131: c_location_num,
3132: c_distribution_num,
3133: c_level_altered,
3134: --fnd_message.get_String('PO', 'POS_SOURCE_QT_LINE'),
3135: 'ICX_SOURCE_QT_LINE',
3136: get_source_quotation_line(
3137: p_line_from.from_line_id ),
3138: get_source_quotation_line(
3164: c_line_num,
3165: c_location_num,
3166: c_distribution_num,
3167: c_level_altered,
3168: --fnd_message.get_String('PO', 'POS_HAZARD_CLASS'),
3169: 'ICX_HAZARD_CLASS',
3170: get_hazard_class( p_line_from.hazard_class_id ),
3171: get_hazard_class( p_line_to.hazard_class_id ),
3172: NULL,
3196: c_line_num,
3197: c_location_num,
3198: c_distribution_num,
3199: c_level_altered,
3200: --fnd_message.get_String('PO', 'POS_CONTRACT_NUMBER'),
3201: 'ICX_CONTRACT_NUMBER',
3202: p_line_from.contract_num,
3203: p_line_to.contract_num,
3204: NULL,
3228: c_line_num,
3229: c_location_num,
3230: c_distribution_num,
3231: c_level_altered,
3232: --fnd_message.get_String('PO', 'POS_SUPPLIER_ITEM_NUM'),
3233: 'ICX_SUPPLIER_ITEM_NUM',
3234: p_line_from.vendor_product_num,
3235: p_line_to.vendor_product_num,
3236: NULL,
3260: c_line_num,
3261: c_location_num,
3262: c_distribution_num,
3263: c_level_altered,
3264: --fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
3265: 'ICX_NOTE_TO_VENDOR',
3266: p_line_from.note_to_vendor,
3267: p_line_to.note_to_vendor,
3268: NULL,
3292: c_line_num,
3293: c_location_num,
3294: c_distribution_num,
3295: c_level_altered,
3296: --fnd_message.get_String('PO', 'POS_UN_NUMBER'),
3297: 'ICX_UN_NUMBER',
3298: get_un_number( p_line_from.un_number_id ),
3299: get_un_number( p_line_to.un_number_id ),
3300: NULL,
3324: c_line_num,
3325: c_location_num,
3326: c_distribution_num,
3327: c_level_altered,
3328: --fnd_message.get_String('PO', 'POS_PRICE_TYPE'),
3329: 'ICX_PRICE_TYPE',
3330: get_po_lookup(
3331: 'PRICE TYPE',
3332: p_line_from.price_type_lookup_code ),
3370: c_line_num,
3371: c_location_num,
3372: c_distribution_num,
3373: c_level_altered,
3374: --fnd_message.get_String('PO', 'POS_QUANTITY_AGREED'),
3375: 'ICX_QUANTITY_AGREED',
3376: p_line_from.quantity_committed,
3377: p_line_to.quantity_committed,
3378: NULL,
3411: c_line_num,
3412: c_location_num,
3413: c_distribution_num,
3414: c_level_altered,
3415: --fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
3416: 'ICX_AMOUNT_AGREED',
3417: p_line_from.committed_amount,
3418: p_line_to.committed_amount,
3419: NULL,
3443: c_line_num,
3444: c_location_num,
3445: c_distribution_num,
3446: c_level_altered,
3447: --fnd_message.get_String('PO', 'POS_CLOSED_CODE'),
3448: 'ICX_CLOSED_CODE',
3449: get_po_lookup( 'DOCUMENT STATE',
3450: p_line_from.committed_amount ),
3451: get_po_lookup( 'DOCUMENT STATE',
3574: c_line_num,
3575: c_location_num,
3576: c_distribution_num,
3577: c_level_altered,
3578: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
3579: 'ICX_EXPIRATION_DATE',
3580: --start bug 4179194
3581: /* to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
3582: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
3943: c_line_num,
3944: c_location_num,
3945: c_distribution_num,
3946: c_level_altered,
3947: --fnd_message.get_String('PO', 'POS_NEW'),
3948: 'ICX_NEW',
3949: NULL,
3950: NULL,
3951: NULL,
4043: c_line_num,
4044: c_location_num,
4045: c_distribution_num,
4046: c_level_altered,
4047: --fnd_message.get_string('PO', 'POS_CANCELLED'),
4048: 'ICX_CANCELLED',
4049: NULL,
4050: NULL,
4051: NULL,
4082: c_line_num,
4083: c_location_num,
4084: c_distribution_num,
4085: c_level_altered,
4086: --fnd_message.get_String('PO', 'POS_SHIP_NUM'),
4087: 'ICX_SHIP_NUM',
4088: p_loc_from.shipment_num,
4089: p_loc_to.shipment_num,
4090: NULL,
4114: c_line_num,
4115: c_location_num,
4116: c_distribution_num,
4117: c_level_altered,
4118: --fnd_message.get_String('PO', 'POS_SHIP_TO'),
4119: 'ICX_SHIP_TO',
4120: get_location( p_loc_from.ship_to_location_id ),
4121: get_location( p_loc_to.ship_to_location_id ),
4122: NULL,
4146: c_line_num,
4147: c_location_num,
4148: c_distribution_num,
4149: c_level_altered,
4150: --fnd_message.get_String('PO', 'POS_QUANTITY'),
4151: 'ICX_QUANTITY',
4152: p_loc_from.quantity,
4153: p_loc_to.quantity,
4154: NULL,
4180: c_line_num,
4181: c_location_num,
4182: c_distribution_num,
4183: c_level_altered,
4184: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
4185: 'ICX_PROMISED_DATE',
4186: null,
4187: null,
4188: null,
4214: c_line_num,
4215: c_location_num,
4216: c_distribution_num,
4217: c_level_altered,
4218: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
4219: 'ICX_NEED_BY_DATE',
4220: null,
4221: null,
4222: null,
4248: c_line_num,
4249: c_location_num,
4250: c_distribution_num,
4251: c_level_altered,
4252: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
4253: 'ICX_LAST_ACCEPT_DATE',
4254: --start bug 4179194
4255: /*
4256: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
4287: c_line_num,
4288: c_location_num,
4289: c_distribution_num,
4290: c_level_altered,
4291: --fnd_message.get_String('PO', 'POS_TAXABLE_FLAG'),
4292: 'ICX_TAXABLE_FLAG',
4293: get_po_lookup(
4294: 'YES/NO',
4295: p_loc_from.taxable_flag ),
4328: c_line_num,
4329: c_location_num,
4330: c_distribution_num,
4331: c_level_altered,
4332: --fnd_message.get_String('PO', 'POS_PRICE_BREAK'),
4333: 'ICX_PRICE_BREAK',
4334: p_loc_from.price_override,
4335: p_loc_to.price_override,
4336: NULL,
4360: c_line_num,
4361: c_location_num,
4362: c_distribution_num,
4363: c_level_altered,
4364: --fnd_message.get_String('PO', 'POS_UNIT_BREAK'),
4365: 'ICX_UNIT_PRICE',
4366: p_loc_from.price_override,
4367: p_loc_to.price_override,
4368: NULL,
4547: IF NVL( p_loc_from.payment_type, ' ' ) <>
4548: NVL( p_loc_to.payment_type, ' ' ) THEN
4549:
4550: if (p_loc_from.payment_type = 'MILESTONE') THEN
4551: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4552: elsif (p_loc_from.payment_type = 'RATE') THEN
4553: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4554: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4555: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4549:
4550: if (p_loc_from.payment_type = 'MILESTONE') THEN
4551: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4552: elsif (p_loc_from.payment_type = 'RATE') THEN
4553: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4554: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4555: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4556: else
4557: v_from_payment_type := p_loc_from.payment_type;
4551: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4552: elsif (p_loc_from.payment_type = 'RATE') THEN
4553: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4554: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4555: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4556: else
4557: v_from_payment_type := p_loc_from.payment_type;
4558: end if;
4559:
4557: v_from_payment_type := p_loc_from.payment_type;
4558: end if;
4559:
4560: if (p_loc_to.payment_type = 'MILESTONE') THEN
4561: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4562: elsif (p_loc_to.payment_type = 'RATE') THEN
4563: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4564: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4565: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4559:
4560: if (p_loc_to.payment_type = 'MILESTONE') THEN
4561: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4562: elsif (p_loc_to.payment_type = 'RATE') THEN
4563: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4564: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4565: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4566: else
4567: v_to_payment_type := p_loc_to.payment_type;
4561: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4562: elsif (p_loc_to.payment_type = 'RATE') THEN
4563: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4564: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4565: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4566: else
4567: v_to_payment_type := p_loc_to.payment_type;
4568: end if;
4569:
4756: c_line_num,
4757: c_location_num,
4758: c_distribution_num,
4759: c_level_altered,
4760: --fnd_message.get_String('PO', 'POS_NEW'),
4761: 'ICX_NEW',
4762: NULL,
4763: NULL
4764: );
4803: c_line_num,
4804: c_location_num,
4805: c_distribution_num,
4806: c_level_altered,
4807: --fnd_message.get_String('PO', 'POS_QUANTITY'),
4808: 'ICX_QUANTITY',
4809: p_dist_from.quantity_ordered,
4810: p_dist_to.quantity_ordered
4811: );
4829: c_line_num,
4830: c_location_num,
4831: c_distribution_num,
4832: c_level_altered,
4833: --fnd_message.get_String('PO', 'POS_REQUESTOR'),
4834: 'ICX_REQUESTOR',
4835: get_requestor(p_dist_from.deliver_to_person_id),
4836: get_requestor(p_dist_to.deliver_to_person_id)
4837: );
4861: c_line_num,
4862: c_location_num,
4863: c_distribution_num,
4864: c_level_altered,
4865: --fnd_message.get_String('PO', 'POS_CHARGE_ACCT'),
4866: 'ICX_CHARGE_ACCT',
4867: get_charge_account(p_dist_from.code_combination_id),
4868: get_charge_account(p_dist_to.code_combination_id)
4869: );