DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PREPROC_PVT dependencies on PO_AUTOCREATE_PARAMS

Line 37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,

33:
34: BEGIN
35:
36: -- po and financials system parameters
37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,
38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,

Line 38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,

34: BEGIN
35:
36: -- po and financials system parameters
37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,
38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,

Line 39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,

35:
36: -- po and financials system parameters
37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,
38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,

Line 40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,

36: -- po and financials system parameters
37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,
38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,

Line 41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,

37: po_core_s.get_po_parameters(PO_AUTOCREATE_PARAMS.g_sys.currency_code,
38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,

Line 42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,

38: PO_AUTOCREATE_PARAMS.g_sys.coa_id,
39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,

Line 43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,

39: PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag,
40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,

Line 44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,

40: PO_AUTOCREATE_PARAMS.g_sys.req_encumbrance_flag,
41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,

Line 45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,

41: PO_AUTOCREATE_PARAMS.g_sys.sob_id,
42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,

Line 46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,

42: PO_AUTOCREATE_PARAMS.g_sys.ship_to_location_id,
43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,

Line 47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,

43: PO_AUTOCREATE_PARAMS.g_sys.bill_to_location_id,
44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,

Line 48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,

44: PO_AUTOCREATE_PARAMS.g_sys.fob_lookup_code,
45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,

Line 49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,

45: PO_AUTOCREATE_PARAMS.g_sys.freight_terms_lookup_code,
46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,

Line 50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,

46: PO_AUTOCREATE_PARAMS.g_sys.terms_id,
47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,

Line 51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,

47: PO_AUTOCREATE_PARAMS.g_sys.default_rate_type,
48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,

Line 52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,

48: PO_AUTOCREATE_PARAMS.g_sys.taxable_flag,
49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,

Line 53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,

49: PO_AUTOCREATE_PARAMS.g_sys.receiving_flag,
50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,

Line 54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,

50: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_name_flag,
51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,

Line 55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,

51: PO_AUTOCREATE_PARAMS.g_sys.enforce_buyer_auth_flag,
52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,

Line 56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,

52: PO_AUTOCREATE_PARAMS.g_sys.line_type_id,
53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,

Line 57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,

53: PO_AUTOCREATE_PARAMS.g_sys.manual_po_num_type,
54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,

Line 58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,

54: PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code,
55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,

Line 59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,

55: PO_AUTOCREATE_PARAMS.g_sys.price_type_lookup_code,
56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,

Line 60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,

56: PO_AUTOCREATE_PARAMS.g_sys.invoice_close_tolerance,
57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,

Line 61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,

57: PO_AUTOCREATE_PARAMS.g_sys.receive_close_tolerance,
58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,

Line 62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,

58: PO_AUTOCREATE_PARAMS.g_sys.security_structure_id,
59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,

Line 63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,

59: PO_AUTOCREATE_PARAMS.g_sys.expense_accrual_code,
60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,

Line 64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,

60: PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id,
61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,

Line 65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,

61: PO_AUTOCREATE_PARAMS.g_sys.rev_sort_ordering,
62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,

Line 66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,

62: PO_AUTOCREATE_PARAMS.g_sys.min_rel_amount,
63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,

Line 67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,

63: PO_AUTOCREATE_PARAMS.g_sys.notify_blanket_flag,
64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,

Line 68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,

64: PO_AUTOCREATE_PARAMS.g_sys.budgetary_control_flag,
65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,

Line 69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,

65: PO_AUTOCREATE_PARAMS.g_sys.user_defined_req_num_code,
66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,

Line 70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,

66: PO_AUTOCREATE_PARAMS.g_sys.rfq_required_flag,
67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,

Line 71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,

67: PO_AUTOCREATE_PARAMS.g_sys.manual_req_num_type,
68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,

Line 72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,

68: PO_AUTOCREATE_PARAMS.g_sys.enforce_full_lot_qty,
69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,

Line 73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,

69: PO_AUTOCREATE_PARAMS.g_sys.disposition_warning_flag,
70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,

Line 74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,

70: PO_AUTOCREATE_PARAMS.g_sys.reserve_at_completion_flag,
71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,

Line 75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,

71: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rcpt_num_code,
72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,

Line 76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,

72: PO_AUTOCREATE_PARAMS.g_sys.manual_rcpt_num_type,
73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,

Line 77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,

73: PO_AUTOCREATE_PARAMS.g_sys.use_positions_flag,
74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,

Line 78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,

74: PO_AUTOCREATE_PARAMS.g_sys.default_quote_warning_delay,
75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);

Line 79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,

75: PO_AUTOCREATE_PARAMS.g_sys.inspection_required_flag,
76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);
83:

Line 80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,

76: PO_AUTOCREATE_PARAMS.g_sys.user_defined_quote_num_code,
77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);
83:
84: l_progress := '010';

Line 81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,

77: PO_AUTOCREATE_PARAMS.g_sys.manual_quote_num_type,
78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);
83:
84: l_progress := '010';
85:

Line 82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);

78: PO_AUTOCREATE_PARAMS.g_sys.user_defined_rfq_num_code,
79: PO_AUTOCREATE_PARAMS.g_sys.manual_rfq_num_type,
80: PO_AUTOCREATE_PARAMS.g_sys.ship_via_lookup_code,
81: PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
82: PO_AUTOCREATE_PARAMS.g_sys.acceptance_required_flag);
83:
84: l_progress := '010';
85:
86: -- receiving parameters for defaulting org

Line 91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,

87: RCV_CORE_S.get_receiving_controls
88: ( x_line_loc_id => NULL,
89: x_item_id => NULL,
90: x_vendor_id => NULL,
91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,
92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,

Line 92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,

88: ( x_line_loc_id => NULL,
89: x_item_id => NULL,
90: x_vendor_id => NULL,
91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,
92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,

Line 93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,

89: x_item_id => NULL,
90: x_vendor_id => NULL,
91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,
92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,

Line 94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,

90: x_vendor_id => NULL,
91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,
92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,

Line 95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,

91: x_org_id => PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id,
92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,
99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception

Line 96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,

92: x_enforce_ship_to_loc => PO_AUTOCREATE_PARAMS.g_sys.enforce_ship_to_loc,
93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,
99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception
100: );

Line 97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,

93: x_allow_substitutes => PO_AUTOCREATE_PARAMS.g_sys.allow_substitutes,
94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,
99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception
100: );
101:

Line 98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,

94: x_routing_id => PO_AUTOCREATE_PARAMS.g_sys.routing_id,
95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,
99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception
100: );
101:
102: EXCEPTION

Line 99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception

95: x_qty_rcv_tolerance => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_tolerance,
96: x_qty_rcv_exception => PO_AUTOCREATE_PARAMS.g_sys.qty_rcv_exception,
97: x_days_early_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_early_receipt,
98: x_days_late_receipt => PO_AUTOCREATE_PARAMS.g_sys.days_late_receipt,
99: x_rcv_date_exception => PO_AUTOCREATE_PARAMS.g_sys.rcv_days_exception
100: );
101:
102: EXCEPTION
103: WHEN OTHERS THEN

Line 135: PO_AUTOCREATE_PARAMS.sys_param_rec_type

131: NAME: process
132: DESC: Main Procedure for the AutoCreate Pre Processing logic which includes
133:
134: - Get System defaults and populate global variables
135: PO_AUTOCREATE_PARAMS.sys_param_rec_type
136:
137: - Lock interface record so that no other process consumes these
138: records. Locking the header interface itself might be sufficient.
139:

Line 169: IF PO_AUTOCREATE_PARAMS.x_orig_org_id IS NOT NULL THEN

165: Catch the Requisition OU Id and set the session to
166: Purchasing OU Id (If required) */
167: l_progress := '010';
168:
169: IF PO_AUTOCREATE_PARAMS.x_orig_org_id IS NOT NULL THEN
170: l_original_operating_unit_id := PO_AUTOCREATE_PARAMS.x_orig_org_id;
171: ELSE
172: l_original_operating_unit_id := po_moac_utils_pvt.get_current_org_id;
173: END IF;

Line 170: l_original_operating_unit_id := PO_AUTOCREATE_PARAMS.x_orig_org_id;

166: Purchasing OU Id (If required) */
167: l_progress := '010';
168:
169: IF PO_AUTOCREATE_PARAMS.x_orig_org_id IS NOT NULL THEN
170: l_original_operating_unit_id := PO_AUTOCREATE_PARAMS.x_orig_org_id;
171: ELSE
172: l_original_operating_unit_id := po_moac_utils_pvt.get_current_org_id;
173: END IF;
174:

Line 178: IF (PO_AUTOCREATE_PARAMS.x_req_operating_unit_id IS NULL) THEN

174:
175: l_progress := '020';
176:
177: -- If requesting Org ID is not passed set it to current operating unit id
178: IF (PO_AUTOCREATE_PARAMS.x_req_operating_unit_id IS NULL) THEN
179: l_req_operating_unit_id := l_original_operating_unit_id;
180: ELSE
181: l_req_operating_unit_id := PO_AUTOCREATE_PARAMS.x_req_operating_unit_id;
182: END IF;

Line 181: l_req_operating_unit_id := PO_AUTOCREATE_PARAMS.x_req_operating_unit_id;

177: -- If requesting Org ID is not passed set it to current operating unit id
178: IF (PO_AUTOCREATE_PARAMS.x_req_operating_unit_id IS NULL) THEN
179: l_req_operating_unit_id := l_original_operating_unit_id;
180: ELSE
181: l_req_operating_unit_id := PO_AUTOCREATE_PARAMS.x_req_operating_unit_id;
182: END IF;
183:
184: l_progress := '030';
185:

Line 187: IF (PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id IS NULL) THEN

183:
184: l_progress := '030';
185:
186: -- If purchasing Org ID is not passed then create PO in Req raising Operating Unit
187: IF (PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id IS NULL) THEN
188: l_purch_operating_unit_id := l_req_operating_unit_id;
189: ELSE
190: l_purch_operating_unit_id := PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id;
191: END IF;

Line 190: l_purch_operating_unit_id := PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id;

186: -- If purchasing Org ID is not passed then create PO in Req raising Operating Unit
187: IF (PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id IS NULL) THEN
188: l_purch_operating_unit_id := l_req_operating_unit_id;
189: ELSE
190: l_purch_operating_unit_id := PO_AUTOCREATE_PARAMS.x_purch_operating_unit_id;
191: END IF;
192:
193: l_progress := '040';
194:

Line 210: PO_AUTOCREATE_PARAMS.g_purchasing_ou_id := l_purch_operating_unit_id;

206:
207: l_progress := '050';
208:
209: -- Initialize the Operating Units
210: PO_AUTOCREATE_PARAMS.g_purchasing_ou_id := l_purch_operating_unit_id;
211: PO_AUTOCREATE_PARAMS.g_hdr_requesting_ou_id := l_req_operating_unit_id;
212: po_autocreate_params.g_org_context_changed := l_org_context_changed;
213: po_autocreate_params.g_original_operating_unit_id := l_original_operating_unit_id;
214:

Line 211: PO_AUTOCREATE_PARAMS.g_hdr_requesting_ou_id := l_req_operating_unit_id;

207: l_progress := '050';
208:
209: -- Initialize the Operating Units
210: PO_AUTOCREATE_PARAMS.g_purchasing_ou_id := l_purch_operating_unit_id;
211: PO_AUTOCREATE_PARAMS.g_hdr_requesting_ou_id := l_req_operating_unit_id;
212: po_autocreate_params.g_org_context_changed := l_org_context_changed;
213: po_autocreate_params.g_original_operating_unit_id := l_original_operating_unit_id;
214:
215: l_progress := '060';

Line 212: po_autocreate_params.g_org_context_changed := l_org_context_changed;

208:
209: -- Initialize the Operating Units
210: PO_AUTOCREATE_PARAMS.g_purchasing_ou_id := l_purch_operating_unit_id;
211: PO_AUTOCREATE_PARAMS.g_hdr_requesting_ou_id := l_req_operating_unit_id;
212: po_autocreate_params.g_org_context_changed := l_org_context_changed;
213: po_autocreate_params.g_original_operating_unit_id := l_original_operating_unit_id;
214:
215: l_progress := '060';
216:

Line 213: po_autocreate_params.g_original_operating_unit_id := l_original_operating_unit_id;

209: -- Initialize the Operating Units
210: PO_AUTOCREATE_PARAMS.g_purchasing_ou_id := l_purch_operating_unit_id;
211: PO_AUTOCREATE_PARAMS.g_hdr_requesting_ou_id := l_req_operating_unit_id;
212: po_autocreate_params.g_org_context_changed := l_org_context_changed;
213: po_autocreate_params.g_original_operating_unit_id := l_original_operating_unit_id;
214:
215: l_progress := '060';
216:
217: -- Determine the document_type, document_subtype and interface_source_code

Line 226: INTO PO_AUTOCREATE_PARAMS.g_document_type,

222: group_code,
223: document_num,
224: process_code,
225: draft_id
226: INTO PO_AUTOCREATE_PARAMS.g_document_type,
227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,

Line 227: PO_AUTOCREATE_PARAMS.g_document_subtype,

223: document_num,
224: process_code,
225: draft_id
226: INTO PO_AUTOCREATE_PARAMS.g_document_type,
227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,

Line 228: PO_AUTOCREATE_PARAMS.g_interface_source_code,

224: process_code,
225: draft_id
226: INTO PO_AUTOCREATE_PARAMS.g_document_type,
227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project

Line 229: PO_AUTOCREATE_PARAMS.g_mode,

225: draft_id
226: INTO PO_AUTOCREATE_PARAMS.g_document_type,
227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project
233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.

Line 230: PO_AUTOCREATE_PARAMS.g_group_code,

226: INTO PO_AUTOCREATE_PARAMS.g_document_type,
227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project
233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
234: /*now the draft id is populated from UI.

Line 231: PO_AUTOCREATE_PARAMS.g_old_document_num,

227: PO_AUTOCREATE_PARAMS.g_document_subtype,
228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project
233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
234: /*now the draft id is populated from UI.
235: this draft_id will be used all along*/

Line 232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project

228: PO_AUTOCREATE_PARAMS.g_interface_source_code,
229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project
233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
234: /*now the draft id is populated from UI.
235: this draft_id will be used all along*/
236: FROM po_headers_interface

Line 233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.

229: PO_AUTOCREATE_PARAMS.g_mode,
230: PO_AUTOCREATE_PARAMS.g_group_code,
231: PO_AUTOCREATE_PARAMS.g_old_document_num,
232: PO_AUTOCREATE_PARAMS.g_process_code, -- Add to modification project
233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
234: /*now the draft id is populated from UI.
235: this draft_id will be used all along*/
236: FROM po_headers_interface
237: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;

Line 237: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;

233: PO_AUTOCREATE_PARAMS.g_draft_id -- CLM Phase2 autocreate grouping.
234: /*now the draft id is populated from UI.
235: this draft_id will be used all along*/
236: FROM po_headers_interface
237: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
238:
239: l_progress := '070';
240:
241: /*CLM Phase 2 autocreate grouping. commenting out the code to hardcode g_group_code = 'REQUISITION' in case of clm po*/

Line 242: /* IF po_autocreate_params.g_is_clm_po = 'Y'

238:
239: l_progress := '070';
240:
241: /*CLM Phase 2 autocreate grouping. commenting out the code to hardcode g_group_code = 'REQUISITION' in case of clm po*/
242: /* IF po_autocreate_params.g_is_clm_po = 'Y'
243: THEN
244: PO_AUTOCREATE_PARAMS.g_group_code := 'REQUISITION';
245: END IF;*/
246:

Line 244: PO_AUTOCREATE_PARAMS.g_group_code := 'REQUISITION';

240:
241: /*CLM Phase 2 autocreate grouping. commenting out the code to hardcode g_group_code = 'REQUISITION' in case of clm po*/
242: /* IF po_autocreate_params.g_is_clm_po = 'Y'
243: THEN
244: PO_AUTOCREATE_PARAMS.g_group_code := 'REQUISITION';
245: END IF;*/
246:
247: l_progress := '080';
248:

Line 249: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' and

245: END IF;*/
246:
247: l_progress := '080';
248:
249: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' and
250: PO_AUTOCREATE_PARAMS.g_document_subtype in ('STANDARD', 'PLANNED', 'RELEASE')) THEN
251: PO_AUTOCREATE_PARAMS.g_calculate_tax_flag := 'Y';
252: END IF;
253:

Line 250: PO_AUTOCREATE_PARAMS.g_document_subtype in ('STANDARD', 'PLANNED', 'RELEASE')) THEN

246:
247: l_progress := '080';
248:
249: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' and
250: PO_AUTOCREATE_PARAMS.g_document_subtype in ('STANDARD', 'PLANNED', 'RELEASE')) THEN
251: PO_AUTOCREATE_PARAMS.g_calculate_tax_flag := 'Y';
252: END IF;
253:
254: l_progress := '090';

Line 251: PO_AUTOCREATE_PARAMS.g_calculate_tax_flag := 'Y';

247: l_progress := '080';
248:
249: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' and
250: PO_AUTOCREATE_PARAMS.g_document_subtype in ('STANDARD', 'PLANNED', 'RELEASE')) THEN
251: PO_AUTOCREATE_PARAMS.g_calculate_tax_flag := 'Y';
252: END IF;
253:
254: l_progress := '090';
255: