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.

[Home] [Help]

APPS.OKC_PAA_PVT dependencies on OKC_PRICE_ADJ_ATTRIBS

Line 46: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ATTRIBS

42:
43: END api_copy;
44:
45: ---------------------------------------------------------------------------
46: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ATTRIBS
47: ---------------------------------------------------------------------------
48: FUNCTION get_rec (
49: p_paa_rec IN paa_rec_type,
50: x_no_data_found OUT NOCOPY BOOLEAN

Line 72: FROM Okc_Price_Adj_Attribs

68: PROGRAM_ID,
69: PROGRAM_UPDATE_DATE,
70: REQUEST_ID,
71: OBJECT_VERSION_NUMBER
72: FROM Okc_Price_Adj_Attribs
73: WHERE okc_price_adj_attribs.id = p_id;
74: l_paa_pk paa_pk_csr%ROWTYPE;
75: l_paa_rec paa_rec_type;
76: BEGIN

Line 73: WHERE okc_price_adj_attribs.id = p_id;

69: PROGRAM_UPDATE_DATE,
70: REQUEST_ID,
71: OBJECT_VERSION_NUMBER
72: FROM Okc_Price_Adj_Attribs
73: WHERE okc_price_adj_attribs.id = p_id;
74: l_paa_pk paa_pk_csr%ROWTYPE;
75: l_paa_rec paa_rec_type;
76: BEGIN
77:

Line 127: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ATTRIBS_V

123: RETURN(get_rec(p_paa_rec, l_row_notfound));
124:
125: END get_rec;
126: ---------------------------------------------------------------------------
127: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ATTRIBS_V
128: ---------------------------------------------------------------------------
129: FUNCTION get_rec (
130: p_paav_rec IN paav_rec_type,
131: x_no_data_found OUT NOCOPY BOOLEAN

Line 153: FROM Okc_Price_Adj_Attribs_V

149: PROGRAM_ID,
150: PROGRAM_UPDATE_DATE,
151: REQUEST_ID,
152: OBJECT_VERSION_NUMBER
153: FROM Okc_Price_Adj_Attribs_V
154: WHERE okc_price_adj_attribs_v.id = p_id;
155: l_okc_paav_pk okc_paav_pk_csr%ROWTYPE;
156: l_paav_rec paav_rec_type;
157: BEGIN

Line 154: WHERE okc_price_adj_attribs_v.id = p_id;

150: PROGRAM_UPDATE_DATE,
151: REQUEST_ID,
152: OBJECT_VERSION_NUMBER
153: FROM Okc_Price_Adj_Attribs_V
154: WHERE okc_price_adj_attribs_v.id = p_id;
155: l_okc_paav_pk okc_paav_pk_csr%ROWTYPE;
156: l_paav_rec paav_rec_type;
157: BEGIN
158:

Line 209: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ATTRIBS_V --

205:
206: END get_rec;
207:
208: -------------------------------------------------------------
209: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ATTRIBS_V --
210: -------------------------------------------------------------
211: FUNCTION null_out_defaults (
212: p_paav_rec IN paav_rec_type
213: ) RETURN paav_rec_type IS

Line 534: -- Validate_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --

530: ---------------------------------------------------------------------------
531: -- PROCEDURE Validate_Attributes
532: ---------------------------------------------------------------------------
533: -----------------------------------------------------
534: -- Validate_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --
535: -----------------------------------------------------
536: FUNCTION Validate_Attributes (
537: p_paav_rec IN paav_rec_type
538: ) RETURN VARCHAR2 IS

Line 640: -- Validate_Record for:OKC_PRICE_ADJ_ATTRIBS_V --

636: ---------------------------------------------------------------------------
637: -- PROCEDURE Validate_Record
638: ---------------------------------------------------------------------------
639: -------------------------------------------------
640: -- Validate_Record for:OKC_PRICE_ADJ_ATTRIBS_V --
641: -------------------------------------------------
642: FUNCTION Validate_Record (
643: p_paav_rec IN paav_rec_type
644: ) RETURN VARCHAR2 IS

Line 767: -- validate_row for:OKC_PRICE_ADJ_ATTRIBS_V --

763: ---------------------------------------------------------------------------
764: -- PROCEDURE validate_row
765: ---------------------------------------------------------------------------
766: ----------------------------------------------
767: -- validate_row for:OKC_PRICE_ADJ_ATTRIBS_V --
768: ----------------------------------------------
769: PROCEDURE validate_row(
770: p_api_version IN NUMBER,
771: p_init_msg_list IN VARCHAR2 ,

Line 973: -- insert_row for:OKC_PRICE_ADJ_ATTRIBS --

969: ---------------------------------------------------------------------------
970: -- PROCEDURE insert_row
971: ---------------------------------------------------------------------------
972: ------------------------------------------
973: -- insert_row for:OKC_PRICE_ADJ_ATTRIBS --
974: ------------------------------------------
975: PROCEDURE insert_row(
976: p_init_msg_list IN VARCHAR2 ,
977: x_return_status OUT NOCOPY VARCHAR2,

Line 989: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS --

985: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
986: l_paa_rec paa_rec_type := p_paa_rec;
987: l_def_paa_rec paa_rec_type;
988: ----------------------------------------------
989: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS --
990: ----------------------------------------------
991: FUNCTION Set_Attributes (
992: p_paa_rec IN paa_rec_type,
993: x_paa_rec OUT NOCOPY paa_rec_type

Line 1028: INSERT INTO OKC_PRICE_ADJ_ATTRIBS(

1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: INSERT INTO OKC_PRICE_ADJ_ATTRIBS(
1029: id,
1030: pat_id,
1031: flex_title,
1032: pricing_context,

Line 1127: -- insert_row for:OKC_PRICE_ADJ_ATTRIBS_V --

1123: );
1124:
1125: END insert_row;
1126: --------------------------------------------
1127: -- insert_row for:OKC_PRICE_ADJ_ATTRIBS_V --
1128: --------------------------------------------
1129: PROCEDURE insert_row(
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 ,

Line 1164: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --

1160: RETURN(l_paav_rec);
1161:
1162: END fill_who_columns;
1163: ------------------------------------------------
1164: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --
1165: ------------------------------------------------
1166: FUNCTION Set_Attributes (
1167: p_paav_rec IN paav_rec_type,
1168: x_paav_rec OUT NOCOPY paav_rec_type

Line 1408: -- lock_row for:OKC_PRICE_ADJ_ATTRIBS --

1404: ---------------------------------------------------------------------------
1405: -- PROCEDURE lock_row
1406: ---------------------------------------------------------------------------
1407: ----------------------------------------
1408: -- lock_row for:OKC_PRICE_ADJ_ATTRIBS --
1409: ----------------------------------------
1410: PROCEDURE lock_row(
1411: p_init_msg_list IN VARCHAR2 ,
1412: x_return_status OUT NOCOPY VARCHAR2,

Line 1421: FROM OKC_PRICE_ADJ_ATTRIBS

1417: E_Resource_Busy EXCEPTION;
1418: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1419: CURSOR lock_csr (p_paa_rec IN paa_rec_type) IS
1420: SELECT *
1421: FROM OKC_PRICE_ADJ_ATTRIBS
1422: WHERE ID = p_paa_rec.id
1423: FOR UPDATE NOWAIT;
1424:
1425: l_api_version CONSTANT NUMBER := 1;

Line 1615: -- lock_row for:OKC_PRICE_ADJ_ATTRIBS_V --

1611: );
1612:
1613: END lock_row;
1614: ------------------------------------------
1615: -- lock_row for:OKC_PRICE_ADJ_ATTRIBS_V --
1616: ------------------------------------------
1617: PROCEDURE lock_row(
1618: p_api_version IN NUMBER,
1619: p_init_msg_list IN VARCHAR2 ,

Line 1825: -- update_row for:OKC_PRICE_ADJ_ATTRIBS --

1821: ---------------------------------------------------------------------------
1822: -- PROCEDURE update_row
1823: ---------------------------------------------------------------------------
1824: ------------------------------------------
1825: -- update_row for:OKC_PRICE_ADJ_ATTRIBS --
1826: ------------------------------------------
1827: PROCEDURE update_row(
1828: p_init_msg_list IN VARCHAR2 ,
1829: x_return_status OUT NOCOPY VARCHAR2,

Line 1946: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS --

1942: RETURN(l_return_status);
1943:
1944: END populate_new_record;
1945: ----------------------------------------------
1946: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS --
1947: ----------------------------------------------
1948: FUNCTION Set_Attributes (
1949: p_paa_rec IN paa_rec_type,
1950: x_paa_rec OUT NOCOPY paa_rec_type

Line 1991: UPDATE OKC_PRICE_ADJ_ATTRIBS

1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: UPDATE OKC_PRICE_ADJ_ATTRIBS
1992: SET PAT_ID = l_def_paa_rec.pat_id,
1993: FLEX_TITLE = l_def_paa_rec.flex_title,
1994: PRICING_CONTEXT = l_def_paa_rec.pricing_context,
1995: PRICING_ATTRIBUTE = l_def_paa_rec.pricing_attribute,

Line 2071: -- update_row for:OKC_PRICE_ADJ_ATTRIBS_V --

2067: );
2068:
2069: END update_row;
2070: --------------------------------------------
2071: -- update_row for:OKC_PRICE_ADJ_ATTRIBS_V --
2072: --------------------------------------------
2073: PROCEDURE update_row(
2074: p_api_version IN NUMBER,
2075: p_init_msg_list IN VARCHAR2 ,

Line 2209: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --

2205: RETURN(l_return_status);
2206:
2207: END populate_new_record;
2208: ------------------------------------------------
2209: -- Set_Attributes for:OKC_PRICE_ADJ_ATTRIBS_V --
2210: ------------------------------------------------
2211: FUNCTION Set_Attributes (
2212: p_paav_rec IN paav_rec_type,
2213: x_paav_rec OUT NOCOPY paav_rec_type

Line 2456: -- delete_row for:OKC_PRICE_ADJ_ATTRIBS --

2452: ---------------------------------------------------------------------------
2453: -- PROCEDURE delete_row
2454: ---------------------------------------------------------------------------
2455: ------------------------------------------
2456: -- delete_row for:OKC_PRICE_ADJ_ATTRIBS --
2457: ------------------------------------------
2458: PROCEDURE delete_row(
2459: p_init_msg_list IN VARCHAR2 ,
2460: x_return_status OUT NOCOPY VARCHAR2,

Line 2486: DELETE FROM OKC_PRICE_ADJ_ATTRIBS

2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: DELETE FROM OKC_PRICE_ADJ_ATTRIBS
2487: WHERE ID = l_paa_rec.id;
2488:
2489: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2490:

Line 2548: -- delete_row for:OKC_PRICE_ADJ_ATTRIBS_V --

2544: );
2545:
2546: END delete_row;
2547: --------------------------------------------
2548: -- delete_row for:OKC_PRICE_ADJ_ATTRIBS_V --
2549: --------------------------------------------
2550: PROCEDURE delete_row(
2551: p_api_version IN NUMBER,
2552: p_init_msg_list IN VARCHAR2 ,

Line 2769: INSERT INTO okc_price_adj_attribs_h

2765: okc_debug.Set_Indentation('OKC_PAA_PVT');
2766: okc_debug.log('11900: Entered create_version', 2);
2767: END IF;
2768:
2769: INSERT INTO okc_price_adj_attribs_h
2770: (
2771: id,
2772: pat_id,
2773: flex_title,

Line 2810: FROM okc_price_adj_attribs

2806: program_update_date,
2807: request_id,
2808: object_version_number,
2809: p_major_version
2810: FROM okc_price_adj_attribs
2811: WHERE pat_id IN
2812: ( SELECT pat_id
2813: FROM OKC_PRICE_ADJUSTMENTS
2814: WHERE chr_id = p_chr_id

Line 2862: INSERT INTO okc_price_adj_attribs

2858: okc_debug.Set_Indentation('OKC_PAA_PVT');
2859: okc_debug.log('12200: Entered restore_version', 2);
2860: END IF;
2861:
2862: INSERT INTO okc_price_adj_attribs
2863: (
2864: id,
2865: pat_id,
2866: flex_title,

Line 2902: FROM okc_price_adj_attribs_h

2898: program_id,
2899: program_update_date,
2900: request_id,
2901: object_version_number
2902: FROM okc_price_adj_attribs_h
2903: WHERE pat_id IN
2904: ( SELECT pat_id
2905: FROM OKC_PRICE_ADJUSTMENTS
2906: WHERE chr_id = p_chr_id