[Home] [Help]
951: NULL,
952: NULL,
953: NULL,
954: 'ICX_HEADER',
955: --fnd_message.get_String('PO', 'POS_NO_DIFFERENCE'),
956: 'ICX_NO_DIFFERENCE',
957: NULL,
958: NULL
959: );
1090: c_line_num,
1091: c_location_num,
1092: c_distribution_num,
1093: c_level_altered,
1094: --fnd_message.get_String('POS', 'POS_ERROR'),
1095: 'ICX_ERROR',
1096: NULL,
1097: NULL
1098: );
1131: c_line_num,
1132: c_location_num,
1133: c_distribution_num,
1134: c_level_altered,
1135: --fnd_message.get_string('POS', 'POS_CANCELLED'),
1136: 'ICX_CANCELLED',
1137: NULL,
1138: NULL
1139: );
1161: c_line_num,
1162: c_location_num,
1163: c_distribution_num,
1164: c_level_altered,
1165: --fnd_message.get_String('POS', 'POS_BUYER'),
1166: 'ICX_BUYER',
1167: get_buyer( p_po_from.agent_id ),
1168: get_buyer( p_po_to.agent_id )
1169: );
1187: c_line_num,
1188: c_location_num,
1189: c_distribution_num,
1190: c_level_altered,
1191: --fnd_message.get_String('POS', 'POS_SUPPLIER_CONTACT'),
1192: 'ICX_SUPPLIER_CONTACT',
1193: get_vendor_contact( p_po_from.vendor_contact_id ),
1194: get_vendor_contact( p_po_to.vendor_contact_id )
1195: );
1213: c_line_num,
1214: c_location_num,
1215: c_distribution_num,
1216: c_level_altered,
1217: --fnd_message.get_String('POS', 'POS_CONFIRMED'),
1218: 'ICX_CONFIRMED',
1219: p_po_from.confirming_order_flag,
1220: p_po_to.confirming_order_flag
1221: );
1239: c_line_num,
1240: c_location_num,
1241: c_distribution_num,
1242: c_level_altered,
1243: --fnd_message.get_String('POS', 'POS_SHIP_TO'),
1244: 'ICX_SHIP_TO',
1245: get_location( p_po_from.ship_to_location_id ),
1246: get_location( p_po_to.ship_to_location_id )
1247: );
1265: c_line_num,
1266: c_location_num,
1267: c_distribution_num,
1268: c_level_altered,
1269: --fnd_message.get_String('PO', 'POS_BILL_TO'),
1270: 'ICX_BILL_TO',
1271: get_location( p_po_from.bill_to_location_id ),
1272: get_location( p_po_to.bill_to_location_id )
1273: );
1290: c_line_num,
1291: c_location_num,
1292: c_distribution_num,
1293: c_level_altered,
1294: --fnd_message.get_String('PO', 'POS_PAYMENT_TERMS'),
1295: 'ICX_PAYMENT_TERMS',
1296: get_ap_terms( p_po_from.terms_id ),
1297: get_ap_terms( p_po_to.terms_id )
1298: );
1335: c_line_num,
1336: c_location_num,
1337: c_distribution_num,
1338: c_level_altered,
1339: --fnd_message.get_String('PO', 'POS_AMOUNT'),
1340: 'ICX_AMOUNT',
1341: v_amount_from,
1342: v_amount_to
1343: );
1363: c_line_num,
1364: c_location_num,
1365: c_distribution_num,
1366: c_level_altered,
1367: --fnd_message.get_String('PO', 'POS_SHIP_VIA'),
1368: 'ICX_SHIP_VIA',
1369: p_po_from.ship_via_lookup_code,
1370: p_po_to.ship_via_lookup_code
1371: );
1389: c_line_num,
1390: c_location_num,
1391: c_distribution_num,
1392: c_level_altered,
1393: --fnd_message.get_String('PO', 'POS_FOB'),
1394: 'ICX_FOB',
1395: get_po_lookup( 'FOB', p_po_from.fob_lookup_code ),
1396: get_po_lookup( 'FOB', p_po_to.fob_lookup_code )
1397: );
1415: c_line_num,
1416: c_location_num,
1417: c_distribution_num,
1418: c_level_altered,
1419: --fnd_message.get_String('PO', 'POS_FREIGHT_TERMS'),
1420: 'ICX_FREIGHT_TERMS',
1421: get_po_lookup(
1422: 'FREIGHT TERMS',
1423: p_po_from.freight_terms_lookup_code ),
1445: c_line_num,
1446: c_location_num,
1447: c_distribution_num,
1448: c_level_altered,
1449: --fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
1450: 'ICX_NOTE_TO_VENDOR',
1451: p_po_from.note_to_vendor,
1452: p_po_to.note_to_vendor
1453: );
1471: c_line_num,
1472: c_location_num,
1473: c_distribution_num,
1474: c_level_altered,
1475: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
1476: 'ICX_ACCEPTANCE_REQUIRED',
1477: p_po_from.acceptance_required_flag,
1478: p_po_to.acceptance_required_flag
1479: );
1499: c_line_num,
1500: c_location_num,
1501: c_distribution_num,
1502: c_level_altered,
1503: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1504: 'ICX_ACCEPTANCE_DUE_DATE',
1505: --start bug 4179194
1506: /* to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1507: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1535: c_line_num,
1536: c_location_num,
1537: c_distribution_num,
1538: c_level_altered,
1539: --fnd_message.get_String('PO', 'POS_AMOUNT_LIMIT'),
1540: 'ICX_AMOUNT_LIMIT',
1541: p_po_from.amount_limit,
1542: p_po_to.amount_limit
1543: );
1562: c_line_num,
1563: c_location_num,
1564: c_distribution_num,
1565: c_level_altered,
1566: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1567: 'ICX_START_DATE',
1568: --start bug 4179194
1569: /* to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1570: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1601: c_line_num,
1602: c_location_num,
1603: c_distribution_num,
1604: c_level_altered,
1605: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1606: 'ICX_EXPIRATION_DATE',
1607: --start bug 4179194
1608: /* to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1609: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1637: c_line_num,
1638: c_location_num,
1639: c_distribution_num,
1640: c_level_altered,
1641: --fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
1642: 'ICX_AMOUNT_AGREED',
1643: p_po_from.blanket_total_amount,
1644: p_po_to.blanket_total_amount
1645: );
1897: c_line_num,
1898: c_location_num,
1899: c_distribution_num,
1900: c_level_altered,
1901: --fnd_message.get_String('PO', 'POS_NEW'),
1902: 'ICX_NEW',
1903: NULL,
1904: NULL
1905: );
1946: c_line_num,
1947: c_location_num,
1948: c_distribution_num,
1949: c_level_altered,
1950: --fnd_message.get_string('PO', 'POS_CANCELLED'),
1951: 'ICX_CANCELLED',
1952: NULL,
1953: NULL
1954: );
1973: c_line_num,
1974: c_location_num,
1975: c_distribution_num,
1976: c_level_altered,
1977: --fnd_message.get_String('PO', 'POS_BUYER'),
1978: 'ICX_BUYER',
1979: get_buyer( p_release_from.agent_id ),
1980: get_buyer( p_release_to.agent_id )
1981: );
2005: c_line_num,
2006: c_location_num,
2007: c_distribution_num,
2008: c_level_altered,
2009: --fnd_message.get_String('PO', 'POS_AMOUNT'),
2010: 'ICX_AMOUNT',
2011: v_amount_from,
2012: v_amount_to
2013: );
2033: c_line_num,
2034: c_location_num,
2035: c_distribution_num,
2036: c_level_altered,
2037: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
2038: 'ICX_ACCEPTANCE_DUE_DATE',
2039: --start bug 4179194
2040: /* to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2041: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2069: c_line_num,
2070: c_location_num,
2071: c_distribution_num,
2072: c_level_altered,
2073: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_REQUIRED'),
2074: 'ICX_ACCEPTANCE_REQUIRED',
2075: p_release_from.acceptance_required_flag,
2076: p_release_to.acceptance_required_flag
2077: );
2095: c_line_num,
2096: c_location_num,
2097: c_distribution_num,
2098: c_level_altered,
2099: --fnd_message.get_String('PO', 'POS_RELEASE_NUMBER'),
2100: 'ICX_RELEASE_NUMBER',
2101: p_release_from.release_num,
2102: p_release_to.release_num
2103: );
2123: c_line_num,
2124: c_location_num,
2125: c_distribution_num,
2126: c_level_altered,
2127: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
2128: 'ICX_RELEASE_DATE',
2129: --start bug 4179194
2130: /* to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2131: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2764: c_line_num,
2765: c_location_num,
2766: c_distribution_num,
2767: c_level_altered,
2768: --fnd_message.get_string('PO', 'POS_CANCELLED'),
2769: 'ICX_CANCELLED',
2770: NULL,
2771: NULL,
2772: NULL,
2803: c_line_num,
2804: c_location_num,
2805: c_distribution_num,
2806: c_level_altered,
2807: --fnd_message.get_String('PO', 'POS_UNIT_PRICE'),
2808: 'ICX_UNIT_PRICE',
2809: p_line_from.unit_price,
2810: p_line_to.unit_price,
2811: NULL,
2835: c_line_num,
2836: c_location_num,
2837: c_distribution_num,
2838: c_level_altered,
2839: --fnd_message.get_String('PO', 'POS_LINE_NUMBER'),
2840: 'ICX_LINE_NUMBER',
2841: p_line_from.line_num,
2842: p_line_to.line_num,
2843: NULL,
2867: c_line_num,
2868: c_location_num,
2869: c_distribution_num,
2870: c_level_altered,
2871: --fnd_message.get_String('PO', 'POS_ITEM'),
2872: 'ICX_ITEM',
2873: -- get_item_number( p_line_from.item_id ),
2874: -- get_item_number( p_line_to.item_id ),
2875: get_item( p_line_from.item_id, p_line_from.org_id ),
2901: c_line_num,
2902: c_location_num,
2903: c_distribution_num,
2904: c_level_altered,
2905: --fnd_message.get_String('PO', 'POS_ITEM'),
2906: 'ICX_JOB',
2907: get_job( p_line_from.job_id),
2908: get_job( p_line_to.job_id),
2909: NULL,
2964: c_line_num,
2965: c_location_num,
2966: c_distribution_num,
2967: c_level_altered,
2968: --fnd_message.get_String('PO', 'POS_ITEM_REVISION'),
2969: 'ICX_ITEM_REVISION',
2970: p_line_from.item_revision,
2971: p_line_to.item_revision,
2972: NULL,
2996: c_line_num,
2997: c_location_num,
2998: c_distribution_num,
2999: c_level_altered,
3000: --fnd_message.get_String('PO', 'POS_ITEM_DESCRIPTION'),
3001: 'ICX_ITEM_DESCRIPTION',
3002: p_line_from.item_description,
3003: p_line_to.item_description,
3004: NULL,
3028: c_line_num,
3029: c_location_num,
3030: c_distribution_num,
3031: c_level_altered,
3032: --fnd_message.get_String('PO', 'POS_QUANTITY'),
3033: 'ICX_QUANTITY',
3034: p_line_from.quantity,
3035: p_line_to.quantity,
3036: NULL,
3060: c_line_num,
3061: c_location_num,
3062: c_distribution_num,
3063: c_level_altered,
3064: --fnd_message.get_String('PO', 'POS_UOM'),
3065: 'ICX_UOM',
3066: p_line_from.unit_meas_lookup_code,
3067: p_line_to.unit_meas_lookup_code,
3068: NULL,
3092: c_line_num,
3093: c_location_num,
3094: c_distribution_num,
3095: c_level_altered,
3096: --fnd_message.get_String('PO', 'POS_SOURCE_QT_HEADER'),
3097: 'ICX_SOURCE_QT_HEADER',
3098: get_source_quotation_header(
3099: p_line_from.from_header_id ),
3100: get_source_quotation_header(
3126: c_line_num,
3127: c_location_num,
3128: c_distribution_num,
3129: c_level_altered,
3130: --fnd_message.get_String('PO', 'POS_SOURCE_QT_LINE'),
3131: 'ICX_SOURCE_QT_LINE',
3132: get_source_quotation_line(
3133: p_line_from.from_line_id ),
3134: get_source_quotation_line(
3160: c_line_num,
3161: c_location_num,
3162: c_distribution_num,
3163: c_level_altered,
3164: --fnd_message.get_String('PO', 'POS_HAZARD_CLASS'),
3165: 'ICX_HAZARD_CLASS',
3166: get_hazard_class( p_line_from.hazard_class_id ),
3167: get_hazard_class( p_line_to.hazard_class_id ),
3168: NULL,
3192: c_line_num,
3193: c_location_num,
3194: c_distribution_num,
3195: c_level_altered,
3196: --fnd_message.get_String('PO', 'POS_CONTRACT_NUMBER'),
3197: 'ICX_CONTRACT_NUMBER',
3198: p_line_from.contract_num,
3199: p_line_to.contract_num,
3200: NULL,
3224: c_line_num,
3225: c_location_num,
3226: c_distribution_num,
3227: c_level_altered,
3228: --fnd_message.get_String('PO', 'POS_SUPPLIER_ITEM_NUM'),
3229: 'ICX_SUPPLIER_ITEM_NUM',
3230: p_line_from.vendor_product_num,
3231: p_line_to.vendor_product_num,
3232: NULL,
3256: c_line_num,
3257: c_location_num,
3258: c_distribution_num,
3259: c_level_altered,
3260: --fnd_message.get_String('PO', 'POS_NOTE_TO_VENDOR'),
3261: 'ICX_NOTE_TO_VENDOR',
3262: p_line_from.note_to_vendor,
3263: p_line_to.note_to_vendor,
3264: NULL,
3288: c_line_num,
3289: c_location_num,
3290: c_distribution_num,
3291: c_level_altered,
3292: --fnd_message.get_String('PO', 'POS_UN_NUMBER'),
3293: 'ICX_UN_NUMBER',
3294: get_un_number( p_line_from.un_number_id ),
3295: get_un_number( p_line_to.un_number_id ),
3296: NULL,
3320: c_line_num,
3321: c_location_num,
3322: c_distribution_num,
3323: c_level_altered,
3324: --fnd_message.get_String('PO', 'POS_PRICE_TYPE'),
3325: 'ICX_PRICE_TYPE',
3326: get_po_lookup(
3327: 'PRICE TYPE',
3328: p_line_from.price_type_lookup_code ),
3366: c_line_num,
3367: c_location_num,
3368: c_distribution_num,
3369: c_level_altered,
3370: --fnd_message.get_String('PO', 'POS_QUANTITY_AGREED'),
3371: 'ICX_QUANTITY_AGREED',
3372: p_line_from.quantity_committed,
3373: p_line_to.quantity_committed,
3374: NULL,
3407: c_line_num,
3408: c_location_num,
3409: c_distribution_num,
3410: c_level_altered,
3411: --fnd_message.get_String('PO', 'POS_AMOUNT_AGREED'),
3412: 'ICX_AMOUNT_AGREED',
3413: p_line_from.committed_amount,
3414: p_line_to.committed_amount,
3415: NULL,
3439: c_line_num,
3440: c_location_num,
3441: c_distribution_num,
3442: c_level_altered,
3443: --fnd_message.get_String('PO', 'POS_CLOSED_CODE'),
3444: 'ICX_CLOSED_CODE',
3445: get_po_lookup( 'DOCUMENT STATE',
3446: p_line_from.committed_amount ),
3447: get_po_lookup( 'DOCUMENT STATE',
3570: c_line_num,
3571: c_location_num,
3572: c_distribution_num,
3573: c_level_altered,
3574: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
3575: 'ICX_EXPIRATION_DATE',
3576: --start bug 4179194
3577: /* to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
3578: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
3939: c_line_num,
3940: c_location_num,
3941: c_distribution_num,
3942: c_level_altered,
3943: --fnd_message.get_String('PO', 'POS_NEW'),
3944: 'ICX_NEW',
3945: NULL,
3946: NULL,
3947: NULL,
4039: c_line_num,
4040: c_location_num,
4041: c_distribution_num,
4042: c_level_altered,
4043: --fnd_message.get_string('PO', 'POS_CANCELLED'),
4044: 'ICX_CANCELLED',
4045: NULL,
4046: NULL,
4047: NULL,
4078: c_line_num,
4079: c_location_num,
4080: c_distribution_num,
4081: c_level_altered,
4082: --fnd_message.get_String('PO', 'POS_SHIP_NUM'),
4083: 'ICX_SHIP_NUM',
4084: p_loc_from.shipment_num,
4085: p_loc_to.shipment_num,
4086: NULL,
4110: c_line_num,
4111: c_location_num,
4112: c_distribution_num,
4113: c_level_altered,
4114: --fnd_message.get_String('PO', 'POS_SHIP_TO'),
4115: 'ICX_SHIP_TO',
4116: get_location( p_loc_from.ship_to_location_id ),
4117: get_location( p_loc_to.ship_to_location_id ),
4118: NULL,
4142: c_line_num,
4143: c_location_num,
4144: c_distribution_num,
4145: c_level_altered,
4146: --fnd_message.get_String('PO', 'POS_QUANTITY'),
4147: 'ICX_QUANTITY',
4148: p_loc_from.quantity,
4149: p_loc_to.quantity,
4150: NULL,
4176: c_line_num,
4177: c_location_num,
4178: c_distribution_num,
4179: c_level_altered,
4180: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
4181: 'ICX_PROMISED_DATE',
4182: null,
4183: null,
4184: null,
4210: c_line_num,
4211: c_location_num,
4212: c_distribution_num,
4213: c_level_altered,
4214: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
4215: 'ICX_NEED_BY_DATE',
4216: null,
4217: null,
4218: null,
4244: c_line_num,
4245: c_location_num,
4246: c_distribution_num,
4247: c_level_altered,
4248: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
4249: 'ICX_LAST_ACCEPT_DATE',
4250: --start bug 4179194
4251: /*
4252: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
4283: c_line_num,
4284: c_location_num,
4285: c_distribution_num,
4286: c_level_altered,
4287: --fnd_message.get_String('PO', 'POS_TAXABLE_FLAG'),
4288: 'ICX_TAXABLE_FLAG',
4289: get_po_lookup(
4290: 'YES/NO',
4291: p_loc_from.taxable_flag ),
4324: c_line_num,
4325: c_location_num,
4326: c_distribution_num,
4327: c_level_altered,
4328: --fnd_message.get_String('PO', 'POS_PRICE_BREAK'),
4329: 'ICX_PRICE_BREAK',
4330: p_loc_from.price_override,
4331: p_loc_to.price_override,
4332: NULL,
4354: c_line_num,
4355: c_location_num,
4356: c_distribution_num,
4357: c_level_altered,
4358: --fnd_message.get_String('PO', 'POS_UNIT_BREAK'),
4359: 'ICX_UNIT_PRICE',
4360: p_loc_from.price_override,
4361: p_loc_to.price_override,
4362: NULL,
4541: IF NVL( p_loc_from.payment_type, ' ' ) <>
4542: NVL( p_loc_to.payment_type, ' ' ) THEN
4543:
4544: if (p_loc_from.payment_type = 'MILESTONE') THEN
4545: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4546: elsif (p_loc_from.payment_type = 'RATE') THEN
4547: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4548: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4549: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4543:
4544: if (p_loc_from.payment_type = 'MILESTONE') THEN
4545: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4546: elsif (p_loc_from.payment_type = 'RATE') THEN
4547: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4548: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4549: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4550: else
4551: v_from_payment_type := p_loc_from.payment_type;
4545: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4546: elsif (p_loc_from.payment_type = 'RATE') THEN
4547: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4548: elsif (p_loc_from.payment_type = 'LUMPSUM') THEN
4549: v_from_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4550: else
4551: v_from_payment_type := p_loc_from.payment_type;
4552: end if;
4553:
4551: v_from_payment_type := p_loc_from.payment_type;
4552: end if;
4553:
4554: if (p_loc_to.payment_type = 'MILESTONE') THEN
4555: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4556: elsif (p_loc_to.payment_type = 'RATE') THEN
4557: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4558: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4559: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4553:
4554: if (p_loc_to.payment_type = 'MILESTONE') THEN
4555: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4556: elsif (p_loc_to.payment_type = 'RATE') THEN
4557: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4558: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4559: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4560: else
4561: v_to_payment_type := p_loc_to.payment_type;
4555: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_MILE');
4556: elsif (p_loc_to.payment_type = 'RATE') THEN
4557: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_RATE');
4558: elsif (p_loc_to.payment_type = 'LUMPSUM') THEN
4559: v_to_payment_type := fnd_message.get_String('POS','POS_PROG_PAY_LUMP');
4560: else
4561: v_to_payment_type := p_loc_to.payment_type;
4562: end if;
4563:
4750: c_line_num,
4751: c_location_num,
4752: c_distribution_num,
4753: c_level_altered,
4754: --fnd_message.get_String('PO', 'POS_NEW'),
4755: 'ICX_NEW',
4756: NULL,
4757: NULL
4758: );
4797: c_line_num,
4798: c_location_num,
4799: c_distribution_num,
4800: c_level_altered,
4801: --fnd_message.get_String('PO', 'POS_QUANTITY'),
4802: 'ICX_QUANTITY',
4803: p_dist_from.quantity_ordered,
4804: p_dist_to.quantity_ordered
4805: );
4823: c_line_num,
4824: c_location_num,
4825: c_distribution_num,
4826: c_level_altered,
4827: --fnd_message.get_String('PO', 'POS_REQUESTOR'),
4828: 'ICX_REQUESTOR',
4829: get_requestor(p_dist_from.deliver_to_person_id),
4830: get_requestor(p_dist_to.deliver_to_person_id)
4831: );
4855: c_line_num,
4856: c_location_num,
4857: c_distribution_num,
4858: c_level_altered,
4859: --fnd_message.get_String('PO', 'POS_CHARGE_ACCT'),
4860: 'ICX_CHARGE_ACCT',
4861: get_charge_account(p_dist_from.code_combination_id),
4862: get_charge_account(p_dist_to.code_combination_id)
4863: );