eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_R12_CAT_UPG_PVT

Line 8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_DEF_PVT';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
9:
10: -- BEGIN: Forward function declarations
11:
12: PROCEDURE default_info_from_vendor

Line 15: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,

11:
12: PROCEDURE default_info_from_vendor
13: (
14: p_key IN NUMBER,
15: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
16: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
17: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
18: );
19:

Line 23: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

19:
20: PROCEDURE default_vendor_sites
21: (
22: p_key IN NUMBER,
23: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
24: );
25:
26: PROCEDURE default_info_from_vendor_site
27: (

Line 29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,

25:
26: PROCEDURE default_info_from_vendor_site
27: (
28: p_key IN NUMBER,
29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 44: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

40:
41: PROCEDURE default_vendor_contact_info
42: (
43: p_key IN NUMBER,
44: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
45: );
46:
47: PROCEDURE default_buyer
48: (

Line 50: , x_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

46:
47: PROCEDURE default_buyer
48: (
49: p_key IN NUMBER
50: , x_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
51: );
52:
53: -- END: Forward function declarations
54:

Line 78: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

74: --End of Comments
75: --------------------------------------------------------------------------------
76: PROCEDURE default_headers
77: (
78: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
79: )
80: IS
81: l_api_name CONSTANT VARCHAR2(30) := 'default_headers';
82: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 185: p_headers_rec.action(i) <> PO_R12_CAT_UPG_PVT.g_action_header_create) THEN

181: FOR i IN 1 .. p_headers_rec.vendor_id.COUNT
182: LOOP
183: l_progress := '070';
184: IF (--p_headers_rec.has_errors(i) = 'Y' OR
185: p_headers_rec.action(i) <> PO_R12_CAT_UPG_PVT.g_action_header_create) THEN
186: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Skipping rec#'||i||' has_errors='||p_headers_rec.has_errors(i)||'action='||p_headers_rec.action(i)); END IF;
187: goto END_OF_HEADERS_LOOP;
188: END IF;
189:

Line 214: p_headers_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- -12

210: --p_headers_rec.start_date_active(i) := NULL; -- Key Flexfield start date. Not present in interface tables
211: --p_headers_rec.end_date_active(i) := NULL; -- Key Flexfield start date. Not present in interface tables
212: p_headers_rec.last_update_login(i) := FND_GLOBAL.login_id; -- who column
213: p_headers_rec.creation_date(i) := sysdate; -- who column
214: p_headers_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- -12
215:
216: l_progress := '073';
217: --p_headers_rec.vendor_id(i) -- Copy value from interface table
218: --p_headers_rec.vendor_site_id(i) -- Copy value from interface table. If NULL, default as in PDOI

Line 370: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code); END IF;

366: --p_headers_rec.last_updated_program(i) := 'CATALOG_MIGRATION'; -- TODO: Confirm with Sareddy. Not present in interface tables
367: --p_headers_rec.style_id(i) := NULL; -- Not present in 11.5.9, 11.5.10 Not present in interface tables
368:
369: l_progress := '080';
370: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code); END IF;
371: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_site_fob_lookup_codes(i)='||l_site_fob_lookup_codes(i)); END IF;
372: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.fob(i)='||p_headers_rec.fob(i)); END IF;
373:
374: p_headers_rec.fob(i) :=

Line 377: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code));

373:
374: p_headers_rec.fob(i) :=
375: NVL(p_headers_rec.fob(i),
376: NVL(l_site_fob_lookup_codes(i),
377: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code));
378:
379: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.fob(i)='||p_headers_rec.fob(i)); END IF;
380:
381: l_progress := '082';

Line 386: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code));

382: -- default freight_carrier(ship_via_lookup_code)
383: p_headers_rec.freight_carrier(i) :=
384: NVL(p_headers_rec.freight_carrier(i),
385: NVL(l_site_ship_via_lookup_codes(i),
386: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code));
387:
388: l_progress := '083';
389: -- default freight_terms
390: p_headers_rec.freight_terms(i) :=

Line 393: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code));

389: -- default freight_terms
390: p_headers_rec.freight_terms(i) :=
391: NVL(p_headers_rec.freight_terms(i),
392: NVL(l_site_freight_terms_luc(i),
393: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code));
394:
395: l_progress := '084';
396: -- default ship_to_location_id
397: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id); END IF;

Line 397: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id); END IF;

393: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code));
394:
395: l_progress := '084';
396: -- default ship_to_location_id
397: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id); END IF;
398: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_site_ship_to_location_ids(i)='||l_site_ship_to_location_ids(i)); END IF;
399: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.ship_to_location_id(i)='||p_headers_rec.ship_to_location_id(i)); END IF;
400:
401: p_headers_rec.ship_to_location_id(i) :=

Line 404: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id));

400:
401: p_headers_rec.ship_to_location_id(i) :=
402: NVL(p_headers_rec.ship_to_location_id(i),
403: NVL(l_site_ship_to_location_ids(i),
404: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id));
405:
406: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.ship_to_location_id(i)=<'||p_headers_rec.ship_to_location_id(i)||'>'); END IF;
407:
408: l_progress := '085';

Line 413: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id));

409: -- default bill_to_location_id
410: p_headers_rec.bill_to_location_id(i) :=
411: NVL(p_headers_rec.bill_to_location_id(i),
412: NVL(l_site_bill_to_location_ids(i),
413: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id));
414:
415: l_progress := '086';
416: -- default currency_code
417: p_headers_rec.currency_code(i) :=

Line 421: PO_R12_CAT_UPG_PVT.g_sys.currency_code)));

417: p_headers_rec.currency_code(i) :=
418: NVL(p_headers_rec.currency_code(i),
419: NVL(l_site_currency_codes(i),
420: NVL(l_vendor_currency_codes(i),
421: PO_R12_CAT_UPG_PVT.g_sys.currency_code)));
422:
423: l_progress := '087';
424: -- default terms_id
425: p_headers_rec.terms_id(i) :=

Line 442: IF (p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code)

438: p_headers_rec.pay_on_code(i) := l_site_pay_on_codes(i);
439:
440: l_progress := '090';
441: -- default rate info after currency default
442: IF (p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code)
443: THEN
444: l_progress := '100';
445: -- deafult rate_date
446: p_headers_rec.rate_date(i) := sysdate;

Line 456: x_to_currency => PO_R12_CAT_UPG_PVT.g_sys.currency_code,

452: BEGIN
453: l_is_fixed_rate := GL_CURRENCY_API.is_fixed_rate
454: (
455: x_from_currency => p_headers_rec.currency_code(i),
456: x_to_currency => PO_R12_CAT_UPG_PVT.g_sys.currency_code,
457: x_effective_date => p_headers_rec.rate_date(i)
458: );
459: EXCEPTION
460: WHEN OTHERS THEN

Line 487: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);

483: p_headers_rec.rate_type_code(i) := 'EMU FIXED';
484: ELSE
485: p_headers_rec.rate_type_code(i) :=
486: NVL(p_headers_rec.rate_type_code(i),
487: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
488: END IF;
489:
490: l_progress := '120';
491: -- default rate

Line 497: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_set_of_books_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id); END IF;

493: (p_headers_rec.rate(i) IS NULL OR
494: p_headers_rec.rate_type_code(i) = 'EMU FIXED')) THEN
495: l_progress := '130';
496: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.get_rate()'); END IF;
497: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_set_of_books_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id); END IF;
498: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_from_currency='||p_headers_rec.currency_code(i)); END IF;
499: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_conversion_date='||p_headers_rec.rate_date(i)); END IF;
500: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_conversion_type='||p_headers_rec.rate_type_code(i)); END IF;
501:

Line 506: x_set_of_books_id => PO_R12_CAT_UPG_PVT.g_sys.sob_id,

502: BEGIN
503: rate := NULL; -- Bug 5461235
504: rate := GL_CURRENCY_API.get_rate
505: (
506: x_set_of_books_id => PO_R12_CAT_UPG_PVT.g_sys.sob_id,
507: x_from_currency => p_headers_rec.currency_code(i),
508: x_conversion_date => p_headers_rec.rate_date(i),
509: x_conversion_type => p_headers_rec.rate_type_code(i)
510: );

Line 637: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,

633: --------------------------------------------------------------------------------
634: PROCEDURE default_info_from_vendor
635: (
636: p_key IN NUMBER,
637: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
638: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
639: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
640: )
641: IS

Line 678: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;

674: FROM po_vendors vendor
675: WHERE vendor.vendor_id = p_headers_rec.vendor_id(i)
676: AND p_headers_rec.vendor_id(i) IS NOT NULL
677: --AND p_headers_rec.has_errors(i) = 'N'
678: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;
679:
680: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
681:
682: l_progress := '030';

Line 747: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

743: --------------------------------------------------------------------------------
744: PROCEDURE default_vendor_sites
745: (
746: p_key IN NUMBER,
747: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
748: )
749: IS
750: l_api_name CONSTANT VARCHAR2(30) := 'default_vendor_sites';
751: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 786: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

782: FROM po_vendor_sites_all vendor_site
783: WHERE p_headers_rec.vendor_id(i) IS NOT NULL
784: AND p_headers_rec.vendor_site_id(i) IS NULL
785: --AND p_headers_rec.has_errors(i) = 'N'
786: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
787: AND vendor_site.vendor_id = p_headers_rec.vendor_id(i)
788: AND vendor_site.purchasing_site_flag = 'Y'
789: AND TRUNC(sysdate) < nvl(vendor_site.inactive_date, TRUNC(sysdate + 1))
790: AND NVL(vendor_site.rfq_only_site_flag, 'N') <> 'Y'

Line 863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,

859: --------------------------------------------------------------------------------
860: PROCEDURE default_info_from_vendor_site
861: (
862: p_key IN NUMBER,
863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 933: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

929: FROM po_vendor_sites_all vendor_site
930: WHERE p_headers_rec.vendor_id(i) IS NOT NULL
931: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
932: --AND p_headers_rec.has_errors(i) = 'N'
933: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
934: AND vendor_site.vendor_site_id = p_headers_rec.vendor_site_id(i)
935: AND vendor_site.purchasing_site_flag = 'Y'
936: AND TRUNC(sysdate) < nvl(vendor_site.inactive_date, TRUNC(sysdate + 1))
937: AND NVL(vendor_site.rfq_only_site_flag, 'N') <> 'Y';

Line 1030: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1026: --------------------------------------------------------------------------------
1027: PROCEDURE default_vendor_contact_info
1028: (
1029: p_key IN NUMBER,
1030: p_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1031: )
1032: IS
1033: l_api_name CONSTANT VARCHAR2(30) := 'default_vendor_contact_info';
1034: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1069: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

1065: WHERE p_headers_rec.vendor_id(i) IS NOT NULL
1066: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
1067: AND p_headers_rec.vendor_contact_id(i) IS NULL
1068: --AND p_headers_rec.has_errors(i) = 'N'
1069: AND p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
1070: AND pvc.vendor_site_id = p_headers_rec.vendor_site_id(i)
1071: AND TRUNC(sysdate) < nvl(pvc.inactive_date, TRUNC(sysdate + 1))
1072: GROUP BY pvc.vendor_site_id
1073: HAVING count(pvc.vendor_contact_id) = 1;

Line 1147: , x_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type

1143: --------------------------------------------------------------------------------
1144: PROCEDURE default_buyer
1145: (
1146: p_key IN NUMBER
1147: , x_headers_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_headers_type
1148: )
1149: IS
1150: l_api_name CONSTANT VARCHAR2(30) := 'default_buyer';
1151: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1183: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create

1179: WHERE POH.po_header_id = x_headers_rec.cpa_reference(i)
1180: AND x_headers_rec.cpa_reference(i) IS NOT NULL
1181: AND x_headers_rec.agent_id(i) IS NULL
1182: --AND x_headers_rec.has_errors(i) = 'N'
1183: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
1184: AND EXISTS
1185: (SELECT 'Its a valid buyer'
1186: FROM PO_BUYERS_VAL_V VALID_BUYER
1187: WHERE VALID_BUYER.employee_id = POH.agent_id);

Line 1253: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;

1249: WHERE rownum = 1
1250: ) SUB_QUERY
1251: WHERE x_headers_rec.agent_id(i) IS NULL
1252: --AND x_headers_rec.has_errors(i) = 'N'
1253: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;
1254:
1255: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1256:
1257: l_progress := '060';

Line 1313: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;

1309: WHERE rownum = 1
1310: ) SUB_QUERY
1311: WHERE x_headers_rec.agent_id(i) IS NULL
1312: --AND x_headers_rec.has_errors(i) = 'N'
1313: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create;
1314:
1315: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1316:
1317: l_progress := '090';

Line 1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,

1350:
1351: PROCEDURE default_hdr_info
1352: (
1353: p_key IN PO_SESSION_GT.key%TYPE,
1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 1367: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1363: PROCEDURE copy_info_from_hdr
1364: (
1365: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1366: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1367: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1368: );
1369:
1370: PROCEDURE default_line_type
1371: (

Line 1374: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1370: PROCEDURE default_line_type
1371: (
1372: p_key IN PO_SESSION_GT.key%TYPE,
1373: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1374: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1375: );
1376:
1377: PROCEDURE default_info_from_line_type
1378: (

Line 1380: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1376:
1377: PROCEDURE default_info_from_line_type
1378: (
1379: p_key IN PO_SESSION_GT.key%TYPE,
1380: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1381: );
1382:
1383: PROCEDURE default_info_from_item
1384: (

Line 1386: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1382:
1383: PROCEDURE default_info_from_item
1384: (
1385: p_key IN PO_SESSION_GT.key%TYPE,
1386: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1387: );
1388:
1389: PROCEDURE default_hzd_cls_from_un_num
1390: (

Line 1392: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1388:
1389: PROCEDURE default_hzd_cls_from_un_num
1390: (
1391: p_key IN PO_SESSION_GT.key%TYPE,
1392: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1393: );
1394:
1395: PROCEDURE get_ship_to_org_from_location
1396: (

Line 1427: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1423: --End of Comments
1424: --------------------------------------------------------------------------------
1425: PROCEDURE default_lines
1426: (
1427: p_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1428: )
1429: IS
1430: l_api_name CONSTANT VARCHAR2(30) := 'default_lines';
1431: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1550: p_lines_rec.action(i) <> PO_R12_CAT_UPG_PVT.g_action_line_create) THEN

1546: FOR i IN 1 .. p_lines_rec.interface_line_id.COUNT
1547: LOOP
1548: l_progress := '110';
1549: IF (--p_lines_rec.has_errors(i) = 'Y' OR
1550: p_lines_rec.action(i) <> PO_R12_CAT_UPG_PVT.g_action_line_create) THEN
1551: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Skipping rec#'||i||' has_errors='||p_lines_rec.has_errors(i)||'action='||p_lines_rec.action(i)); END IF;
1552: goto END_OF_LINES_LOOP;
1553: END IF;
1554:

Line 1586: p_lines_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- NUMBER -12 (suggested by iP)

1582: --p_lines_rec.line_type_id(i) := NULL; -- NOT NULL NUMBER Default as in PDOI(Open issue) In PDOI it is a must column/parameter like buyer
1583: --p_lines_rec.line_num(i) := NULL; -- NOT NULL NUMBER Default as in PDOI
1584: p_lines_rec.last_update_login(i) := FND_GLOBAL.login_id; -- NUMBER FND_GLOBAL.login_id
1585: p_lines_rec.creation_date(i) := sysdate; -- DATE sysdate
1586: p_lines_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- NUMBER -12 (suggested by iP)
1587: --p_lines_rec.item_id(i) := NULL; -- NUMBER Copy value from interface table
1588: --p_lines_rec.item_revision(i) := NULL; -- VARCHAR2(3) Copy value from interface table
1589: --p_lines_rec.category_id(i) := NULL; -- NUMBER Copy value from interface table
1590: --p_lines_rec.item_description(i) := NULL; -- VARCHAR2(240) Copy value from interface table

Line 1644: p_lines_rec.price_type(i) := PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code; -- VARCHAR2(25) Default as in PDOI (iP will not provide)

1640: --p_lines_rec.attribute13(i) := NULL; -- VARCHAR2(150) NULL
1641: --p_lines_rec.attribute14(i) := NULL; -- VARCHAR2(150) NULL
1642: --p_lines_rec.attribute15(i) := NULL; -- VARCHAR2(150) NULL
1643: p_lines_rec.min_release_amount(i) := l_hdr_min_release_amounts(i); -- NUMBER Copy value from header level
1644: p_lines_rec.price_type(i) := PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code; -- VARCHAR2(25) Default as in PDOI (iP will not provide)
1645: p_lines_rec.closed_code(i) := 'OPEN'; -- VARCHAR2(25) OPEN
1646: p_lines_rec.price_break_lookup_code(i) := NULL; -- VARCHAR2(25) NULL (For GA's)
1647: p_lines_rec.ussgl_transaction_code(i) := NULL; -- VARCHAR2(30) NULL
1648: --p_lines_rec.government_context(i) := NULL; -- VARCHAR2(30) NULL -- TODO: ONLY PRESENT IN TXN TABLES

Line 1778: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1774: PROCEDURE copy_info_from_hdr
1775: (
1776: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1777: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1778: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1779: )
1780: IS
1781: l_api_name CONSTANT VARCHAR2(30) := 'copy_info_from_hdr';
1782: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1836: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1832: PROCEDURE default_line_type
1833: (
1834: p_key IN PO_SESSION_GT.key%TYPE,
1835: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1836: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1837: )
1838: IS
1839: l_api_name CONSTANT VARCHAR2(30) := 'default_line_type';
1840: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1877: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;

1873: PO_LINE_TYPES_B POLTB
1874: WHERE PSP.org_id = p_hdr_org_ids(i)
1875: AND PSP.line_type_id = POLTB.line_type_id
1876: --AND x_lines_rec.has_errors(i) = 'N'
1877: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
1878:
1879: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1880:
1881: l_progress := '030';

Line 1943: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

1939: --------------------------------------------------------------------------------
1940: PROCEDURE default_info_from_line_type
1941: (
1942: p_key IN PO_SESSION_GT.key%TYPE,
1943: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1944: )
1945: IS
1946: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_line_type';
1947: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1985: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;

1981: FROM PO_LINE_TYPES_B
1982: WHERE line_type_id = x_lines_rec.line_type_id(i)
1983: AND x_lines_rec.line_type_id(i) IS NOT NULL
1984: --AND x_lines_rec.has_errors(i) = 'N'
1985: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
1986:
1987: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1988:
1989: l_progress := '030';

Line 2050: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

2046: --------------------------------------------------------------------------------
2047: PROCEDURE default_info_from_item
2048: (
2049: p_key IN PO_SESSION_GT.key%TYPE,
2050: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2051: )
2052: IS
2053: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_item';
2054: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2093: AND organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id

2089: market_price,
2090: inspection_required_flag
2091: FROM MTL_SYSTEM_ITEMS_B
2092: WHERE inventory_item_id = x_lines_rec.item_id(i)
2093: AND organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
2094: AND x_lines_rec.item_id(i) IS NOT NULL
2095: --AND x_lines_rec.has_errors(i) = 'N'
2096: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
2097:

Line 2096: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;

2092: WHERE inventory_item_id = x_lines_rec.item_id(i)
2093: AND organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id
2094: AND x_lines_rec.item_id(i) IS NOT NULL
2095: --AND x_lines_rec.has_errors(i) = 'N'
2096: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
2097:
2098: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
2099:
2100: l_progress := '030';

Line 2262: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type

2258: --------------------------------------------------------------------------------
2259: PROCEDURE default_hzd_cls_from_un_num
2260: (
2261: p_key IN PO_SESSION_GT.key%TYPE,
2262: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2263: )
2264: IS
2265: l_api_name CONSTANT VARCHAR2(30) := 'default_hzd_cls_from_un_num';
2266: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2299: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;

2295: WHERE un_number = x_lines_rec.un_number(i)
2296: AND x_lines_rec.un_number(i) IS NOT NULL
2297: AND x_lines_rec.hazard_class_id(i) IS NULL
2298: --AND x_lines_rec.has_errors(i) = 'N'
2299: AND x_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
2300:
2301: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
2302:
2303: l_progress := '030';

Line 2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,

2367: --------------------------------------------------------------------------------
2368: PROCEDURE default_hdr_info
2369: (
2370: p_key IN PO_SESSION_GT.key%TYPE,
2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 2430: AND p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;

2426: PO_HEADERS_INTERFACE POHI
2427: WHERE POH.po_header_id = POHI.po_header_id
2428: AND POHI.interface_header_id = p_lines_rec.interface_header_id(i)
2429: --AND p_lines_rec.has_errors(i) = 'N'
2430: AND p_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create;
2431:
2432: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
2433:
2434: l_progress := '030';