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.OKL_PIT_PVT dependencies on OKL_PRD_PRICE_TMPLS_V

Line 98: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS_V

94: BEGIN
95: RETURN(get_rec(p_pit_rec, l_row_notfound));
96: END get_rec;
97: ---------------------------------------------------------------------------
98: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS_V
99: ---------------------------------------------------------------------------
100: FUNCTION get_rec (
101: p_pitv_rec IN pitv_rec_type,
102: x_no_data_found OUT NOCOPY BOOLEAN

Line 122: FROM Okl_Prd_Price_Tmpls_V

118: CREATION_DATE,
119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Okl_Prd_Price_Tmpls_V
123: WHERE okl_prd_price_tmpls_v.id = p_id;
124: l_okl_pitv_pk okl_pitv_pk_csr%ROWTYPE;
125: l_pitv_rec pitv_rec_type;
126: BEGIN

Line 123: WHERE okl_prd_price_tmpls_v.id = p_id;

119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Okl_Prd_Price_Tmpls_V
123: WHERE okl_prd_price_tmpls_v.id = p_id;
124: l_okl_pitv_pk okl_pitv_pk_csr%ROWTYPE;
125: l_pitv_rec pitv_rec_type;
126: BEGIN
127: x_no_data_found := TRUE;

Line 161: -- FUNCTION null_out_defaults for: OKL_PRD_PRICE_TMPLS_V --

157: RETURN(get_rec(p_pitv_rec, l_row_notfound));
158: END get_rec;
159:
160: -----------------------------------------------------------
161: -- FUNCTION null_out_defaults for: OKL_PRD_PRICE_TMPLS_V --
162: -----------------------------------------------------------
163: FUNCTION null_out_defaults (
164: p_pitv_rec IN pitv_rec_type
165: ) RETURN pitv_rec_type IS

Line 222: -- Validate_Attributes for:OKL_PRD_PRICE_TMPLS_V --

218: ---------------------------------------------------------------------------
219: -- PROCEDURE Validate_Attributes
220: ---------------------------------------------------------------------------
221: ---------------------------------------------------
222: -- Validate_Attributes for:OKL_PRD_PRICE_TMPLS_V --
223: ---------------------------------------------------
224: FUNCTION Validate_Attributes (
225: p_pitv_rec IN pitv_rec_type
226: ) RETURN VARCHAR2 IS

Line 621: FROM OKL_PRD_PRICE_TMPLS_V

617:
618: -- Cursor for PIT Unique Key
619: CURSOR okl_pit_uk_csr(p_rec pitv_rec_type) IS
620: SELECT '1'
621: FROM OKL_PRD_PRICE_TMPLS_V
622: WHERE pdt_id = p_rec.pdt_id
623: AND version = p_rec.version
624: AND id <> NVL(p_rec.id,-9999);
625:

Line 986: -- Validate_Record for:OKL_PRD_PRICE_TMPLS_V --

982: ---------------------------------------------------------------------------
983: -- PROCEDURE Validate_Record
984: ---------------------------------------------------------------------------
985: -----------------------------------------------
986: -- Validate_Record for:OKL_PRD_PRICE_TMPLS_V --
987: -----------------------------------------------
988: FUNCTION Validate_Record (
989: p_pitv_rec IN pitv_rec_type
990: ) RETURN VARCHAR2 IS

Line 1051: -- validate_row for:OKL_PRD_PRICE_TMPLS_V --

1047: ---------------------------------------------------------------------------
1048: -- PROCEDURE validate_row
1049: ---------------------------------------------------------------------------
1050: --------------------------------------------
1051: -- validate_row for:OKL_PRD_PRICE_TMPLS_V --
1052: --------------------------------------------
1053: PROCEDURE validate_row(
1054: p_api_version IN NUMBER,
1055: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1332: -- insert_row for:OKL_PRD_PRICE_TMPLS_V --

1328: '_PVT'
1329: );
1330: END insert_row;
1331: ------------------------------------------
1332: -- insert_row for:OKL_PRD_PRICE_TMPLS_V --
1333: ------------------------------------------
1334: PROCEDURE insert_row(
1335: p_api_version IN NUMBER,
1336: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1366: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --

1362: l_pitv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1363: RETURN(l_pitv_rec);
1364: END fill_who_columns;
1365: ----------------------------------------------
1366: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --
1367: ----------------------------------------------
1368: FUNCTION Set_Attributes (
1369: p_pitv_rec IN pitv_rec_type,
1370: x_pitv_rec OUT NOCOPY pitv_rec_type

Line 1685: -- lock_row for:OKL_PRD_PRICE_TMPLS_V --

1681: '_PVT'
1682: );
1683: END lock_row;
1684: ----------------------------------------
1685: -- lock_row for:OKL_PRD_PRICE_TMPLS_V --
1686: ----------------------------------------
1687: PROCEDURE lock_row(
1688: p_api_version IN NUMBER,
1689: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2033: -- update_row for:OKL_PRD_PRICE_TMPLS_V --

2029: '_PVT'
2030: );
2031: END update_row;
2032: ------------------------------------------
2033: -- update_row for:OKL_PRD_PRICE_TMPLS_V --
2034: ------------------------------------------
2035: PROCEDURE update_row(
2036: p_api_version IN NUMBER,
2037: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2142: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --

2138: END IF;
2139: RETURN(l_return_status);
2140: END populate_new_record;
2141: ----------------------------------------------
2142: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --
2143: ----------------------------------------------
2144: FUNCTION Set_Attributes (
2145: p_pitv_rec IN pitv_rec_type,
2146: x_pitv_rec OUT NOCOPY pitv_rec_type

Line 2405: -- delete_row for:OKL_PRD_PRICE_TMPLS_V --

2401: '_PVT'
2402: );
2403: END delete_row;
2404: ------------------------------------------
2405: -- delete_row for:OKL_PRD_PRICE_TMPLS_V --
2406: ------------------------------------------
2407: PROCEDURE delete_row(
2408: p_api_version IN NUMBER,
2409: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,