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_PDOI_MAINPROC_UTL_PVT dependencies on PO_TBL_NUMBER

Line 13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

9: ) RETURN VARCHAR2;
10:
11: PROCEDURE default_who_columns(
12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,

10:
11: PROCEDURE default_who_columns(
12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE

Line 17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );

Line 18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );
22:

Line 19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );
22:
23: -- line related utility method

Line 26: p_po_header_id_tbl IN PO_TBL_NUMBER,

22:
23: -- line related utility method
24: PROCEDURE calculate_max_line_num
25: (
26: p_po_header_id_tbl IN PO_TBL_NUMBER,
27: p_draft_id_tbl IN PO_TBL_NUMBER
28: );
29:
30: FUNCTION get_next_line_num

Line 27: p_draft_id_tbl IN PO_TBL_NUMBER

23: -- line related utility method
24: PROCEDURE calculate_max_line_num
25: (
26: p_po_header_id_tbl IN PO_TBL_NUMBER,
27: p_draft_id_tbl IN PO_TBL_NUMBER
28: );
29:
30: FUNCTION get_next_line_num
31: (

Line 40: p_po_header_id_tbl IN PO_TBL_NUMBER,

36: RETURN NUMBER;
37:
38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 41: p_draft_id_tbl IN PO_TBL_NUMBER,

37:
38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );

Line 42: p_intf_line_id_tbl IN PO_TBL_NUMBER,

38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );
46:

Line 43: p_line_num_tbl IN PO_TBL_NUMBER,

39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );
46:
47: -- location related utility method

Line 50: p_po_line_id_tbl IN PO_TBL_NUMBER,

46:
47: -- location related utility method
48: PROCEDURE calculate_max_shipment_num
49: (
50: p_po_line_id_tbl IN PO_TBL_NUMBER,
51: p_draft_id_tbl IN PO_TBL_NUMBER
52: );
53:
54: FUNCTION get_next_shipment_num

Line 51: p_draft_id_tbl IN PO_TBL_NUMBER

47: -- location related utility method
48: PROCEDURE calculate_max_shipment_num
49: (
50: p_po_line_id_tbl IN PO_TBL_NUMBER,
51: p_draft_id_tbl IN PO_TBL_NUMBER
52: );
53:
54: FUNCTION get_next_shipment_num
55: (

Line 64: p_po_line_id_tbl IN PO_TBL_NUMBER,

60: RETURN NUMBER;
61:
62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 65: p_draft_id_tbl IN PO_TBL_NUMBER,

61:
62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );

Line 66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,

62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );
70:

Line 67: p_shipment_num_tbl IN PO_TBL_NUMBER,

63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );
70:
71: -- Distribution related utility method

Line 74: p_line_loc_id_tbl IN PO_TBL_NUMBER,

70:
71: -- Distribution related utility method
72: PROCEDURE calculate_max_dist_num
73: (
74: p_line_loc_id_tbl IN PO_TBL_NUMBER,
75: p_draft_id_tbl IN PO_TBL_NUMBER
76: );
77:
78: FUNCTION get_next_dist_num

Line 75: p_draft_id_tbl IN PO_TBL_NUMBER

71: -- Distribution related utility method
72: PROCEDURE calculate_max_dist_num
73: (
74: p_line_loc_id_tbl IN PO_TBL_NUMBER,
75: p_draft_id_tbl IN PO_TBL_NUMBER
76: );
77:
78: FUNCTION get_next_dist_num
79: (

Line 88: p_line_loc_id_tbl IN PO_TBL_NUMBER,

84: RETURN NUMBER;
85:
86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 89: p_draft_id_tbl IN PO_TBL_NUMBER,

85:
86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );

Line 90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );
94:

Line 91: p_dist_num_tbl IN PO_TBL_NUMBER,

87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );
94:
95: -- Price Differential related utility method

Line 99: p_entity_id_tbl IN PO_TBL_NUMBER,

95: -- Price Differential related utility method
96: PROCEDURE calculate_max_price_diff_num
97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:

Line 100: p_draft_id_tbl IN PO_TBL_NUMBER,

96: PROCEDURE calculate_max_price_diff_num
97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:
104: FUNCTION get_next_price_diff_num

Line 101: p_price_diff_num_tbl IN PO_TBL_NUMBER

97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:
104: FUNCTION get_next_price_diff_num
105: (

Line 114: p_entity_id_tbl IN PO_TBL_NUMBER,

110:
111: PROCEDURE check_price_diff_num_unique
112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 115: p_draft_id_tbl IN PO_TBL_NUMBER,

111: PROCEDURE check_price_diff_num_unique
112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );

Line 116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,

112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );
120:

Line 117: p_price_diff_num_tbl IN PO_TBL_NUMBER,

113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );
120:
121: -- utility method used in item creation