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.OKC_OC_INT_PRICING_PVT dependencies on OKC_PRICE_ADJUSTMENT_PUB

Line 35: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value()

31: --get price attribute information from ASO or ONT at the LINE level
32: --and append it to global PL/SQL table g_pavv_tab which will then
33: --contain BOTH header AND line level information
34:
35: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value()
36: --this puts price attributes information in OKC
37: --<>
38:
39:

Line 52: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment()

48: --get price adjustment information from ASO or ONT at the LINE level
49: --and append it to global PL/SQL table g_patv_tab which will then
50: --contain BOTH header AND line level information
51:
52: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment()
53: --this puts price adjustment information in OKC
54:
55: --store the old (ASO or ONT) pat_id's along with the new (OKC) pat_id's
56: --in global PL/SQL table g_price_adjustments_tab for reference later

Line 69: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib()

65: -- g_price_adjustments_tab,
66: --ii) get all the price adjustment attributes
67: -- and store them in global PL/SQL table g_paav_tab
68:
69: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib()
70: --this puts price adjustment attribute information in OKC
71: --<>
72:
73:

Line 83: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc

79: -- g_price_adjustments_tab,
80: --ii) get all the price adjustment relationships
81: -- and store them in global PL/SQL table g_pacv_tab
82:
83: --call OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc
84: --this puts price adjustment relationship information in OKC
85: --<>
86:
87: The OKX related quote pricing views concerned are:

Line 97: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value

93: Flow:
94: |---OKC_OC_INT_PRICING.create_k_pricing()
95: | |---get_price_attr() called twice at header level AND line level
96: | | |---get_pavv_tab() at header level OR line level (as called)
97: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value
98: | |---get_price_adj() called twice at header level AND line level
99: | | |---get_patv_tab() at header level OR line level (as called)
100: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment
101: | |---get_price_adj_attr()

Line 100: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment

96: | | |---get_pavv_tab() at header level OR line level (as called)
97: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value
98: | |---get_price_adj() called twice at header level AND line level
99: | | |---get_patv_tab() at header level OR line level (as called)
100: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment
101: | |---get_price_adj_attr()
102: | | |---get_paav_tab()
103: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib
104: | |---get_price_adj_rltship()

Line 103: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib

Line 106: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc

102: | | |---get_paav_tab()
103: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib
104: | |---get_price_adj_rltship()
105: | | |---get_pacv_tab()
106: | |---OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc
107:
108: END OF PROCESSING FOR QTK or OTK pricing information creation
109: **************************************************************/
110:

Line 121: g_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;

117: -- used to store the old (ASO or ONT) pat_id's along with
118: -- the new (OKC) pat_id's
119:
120: --price attributes
121: g_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
122: lx_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
123:
124: --price adjustments
125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

Line 122: lx_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;

118: -- the new (OKC) pat_id's
119:
120: --price attributes
121: g_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
122: lx_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
123:
124: --price adjustments
125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

Line 125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

121: g_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
122: lx_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
123:
124: --price adjustments
125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
127:
128: --price adjustment attributes
129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

Line 126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;

122: lx_pavv_tab OKC_PRICE_ADJUSTMENT_PUB.pavv_tbl_type;
123:
124: --price adjustments
125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
127:
128: --price adjustment attributes
129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

Line 129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

125: g_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
127:
128: --price adjustment attributes
129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
131:
132: --price adjustment relationships
133: g_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

Line 130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;

126: lx_patv_tab OKC_PRICE_ADJUSTMENT_PUB.patv_tbl_type;
127:
128: --price adjustment attributes
129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
131:
132: --price adjustment relationships
133: g_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
134: lx_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

Line 133: g_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

129: g_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
131:
132: --price adjustment relationships
133: g_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
134: lx_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
135:
136:
137: -- cursor to retrieve the contract number against a given contract id

Line 134: lx_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

130: lx_paav_tab OKC_PRICE_ADJUSTMENT_PUB.paav_tbl_type;
131:
132: --price adjustment relationships
133: g_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
134: lx_pacv_tab OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
135:
136:
137: -- cursor to retrieve the contract number against a given contract id
138: -- this cursor is used to include the contract number in error messages

Line 358: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value');

354: END IF;
355:
356: --now put this price attributes information in OKC
357: IF (l_debug = 'Y') THEN
358: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value');
359: OKC_UTIL.print_trace(2, 'input p_pavv_tbl => g_pavv_tab');
360: END IF;
361: IF g_pavv_tab.FIRST IS NOT NULL THEN
362: OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value(

Line 362: OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value(

358: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value');
359: OKC_UTIL.print_trace(2, 'input p_pavv_tbl => g_pavv_tab');
360: END IF;
361: IF g_pavv_tab.FIRST IS NOT NULL THEN
362: OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value(
363: p_api_version => l_api_version,
364: p_init_msg_list => OKC_API.G_FALSE,
365: x_return_status => l_return_status,
366: x_msg_count => lx_msg_count,

Line 424: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value finished successfully');

420: END IF;
421: END IF;
422:
423: IF (l_debug = 'Y') THEN
424: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_att_value finished successfully');
425: END IF;
426:
427: --<>
428: -----------------------------------------------

Line 482: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment');

478:
479:
480: -- now put this price adjustment information in OKC
481: IF (l_debug = 'Y') THEN
482: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment');
483: OKC_UTIL.print_trace(2, 'input p_patv_tbl => g_patv_tab');
484: END IF;
485: IF g_patv_tab.FIRST IS NOT NULL THEN
486: OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment(

Line 486: OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment(

482: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment');
483: OKC_UTIL.print_trace(2, 'input p_patv_tbl => g_patv_tab');
484: END IF;
485: IF g_patv_tab.FIRST IS NOT NULL THEN
486: OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment(
487: p_api_version => l_api_version,
488: p_init_msg_list => OKC_API.G_FALSE,
489: x_return_status => l_return_status,
490: x_msg_count => lx_msg_count,

Line 548: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment finished successfully.');

544: END IF;
545: END IF;
546:
547: IF (l_debug = 'Y') THEN
548: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adjustment finished successfully.');
549: END IF;
550:
551: -- store the old (ASO or ONT) pat_id's along with the new (OKC) pat_id's
552: -- in global PL/SQL table g_price_adjustments_tab for reference later

Line 590: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib

586: END IF;
587:
588:
589: --now put this price adjustment attribute information in OKC
590: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib
591: IF (l_debug = 'Y') THEN
592: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib');
593: OKC_UTIL.print_trace(2, 'input p_paav_tbl => g_paav_tab');
594: END IF;

Line 592: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib');

588:
589: --now put this price adjustment attribute information in OKC
590: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib
591: IF (l_debug = 'Y') THEN
592: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib');
593: OKC_UTIL.print_trace(2, 'input p_paav_tbl => g_paav_tab');
594: END IF;
595:
596: IF g_paav_tab.FIRST IS NOT NULL THEN

Line 598: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib(

594: END IF;
595:
596: IF g_paav_tab.FIRST IS NOT NULL THEN
597: --now put the price adjustment attributes in OKC
598: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib(
599: p_api_version => l_api_version,
600: p_init_msg_list => OKC_API.G_FALSE,
601: x_return_status => l_return_status,
602: x_msg_count => lx_msg_count,

Line 660: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib finished successfully');

656: END IF;
657: END IF;
658:
659: IF (l_debug = 'Y') THEN
660: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_attrib finished successfully');
661: END IF;
662:
663:
664: --<>

Line 691: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc

687: OKC_UTIL.print_trace(2, 'Call to get_price_adj_rltship finished successfully');
688: END IF;
689:
690: --now put this price adjustment relationship information in OKC
691: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc
692: IF (l_debug = 'Y') THEN
693: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc');
694: OKC_UTIL.print_trace(2, 'input p_pacv_tbl => g_pacv_tab');
695: END IF;

Line 693: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc');

689:
690: --now put this price adjustment relationship information in OKC
691: --by calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc
692: IF (l_debug = 'Y') THEN
693: OKC_UTIL.print_trace(2, ' >Calling OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc');
694: OKC_UTIL.print_trace(2, 'input p_pacv_tbl => g_pacv_tab');
695: END IF;
696:
697: IF g_pacv_tab.FIRST IS NOT NULL THEN

Line 699: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc(

695: END IF;
696:
697: IF g_pacv_tab.FIRST IS NOT NULL THEN
698: --now put the price adjustment relationships in OKC
699: OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc(
700: p_api_version => l_api_version,
701: p_init_msg_list => OKC_API.G_FALSE,
702: x_return_status => l_return_status,
703: x_msg_count => lx_msg_count,

Line 710: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc finished successfully');

706: x_pacv_tbl => lx_pacv_tab);
707: END IF;
708:
709: IF (l_debug = 'Y') THEN
710: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc finished successfully');
711: END IF;
712:
713:
714: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 764: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc finished successfully');

760: END IF;
761: END IF;
762:
763: IF (l_debug = 'Y') THEN
764: OKC_UTIL.print_trace(2, ' >Call to OKC_PRICE_ADJUSTMENT_PUB.create_price_adj_assoc finished successfully');
765: END IF;
766:
767: --<>
768:

Line 1059: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

1055: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
1056: ) IS
1057:
1058:
1059: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
1060: i BINARY_INTEGER;
1061:
1062: x_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
1063:

Line 1062: x_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

1058:
1059: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
1060: i BINARY_INTEGER;
1061:
1062: x_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;
1063:
1064: l_cle_id NUMBER := OKC_API.G_MISS_NUM;
1065: l_new_pat_id NUMBER := OKC_API.G_MISS_NUM;
1066: