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_SCR_PVT dependencies on OKC_K_SALES_CREDITS

Line 38: -- FUNCTION get_rec for: OKC_K_SALES_CREDITS

34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_K_SALES_CREDITS
39: ---------------------------------------------------------------------------
40: FUNCTION get_rec (
41: p_scr_rec IN scr_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN

Line 44: CURSOR okc_k_sales_credits_pk_csr (p_id IN NUMBER) IS

40: FUNCTION get_rec (
41: p_scr_rec IN scr_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
43: ) RETURN scr_rec_type IS
44: CURSOR okc_k_sales_credits_pk_csr (p_id IN NUMBER) IS
45: SELECT
46: ID,
47: PERCENT,
48:

Line 66: FROM Okc_K_Sales_Credits

62: CREATED_BY,
63: CREATION_DATE,
64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE
66: FROM Okc_K_Sales_Credits
67: WHERE okc_k_sales_credits.id = p_id;
68: l_okc_k_sales_credits_pk okc_k_sales_credits_pk_csr%ROWTYPE;
69: l_scr_rec scr_rec_type;
70: BEGIN

Line 67: WHERE okc_k_sales_credits.id = p_id;

63: CREATION_DATE,
64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE
66: FROM Okc_K_Sales_Credits
67: WHERE okc_k_sales_credits.id = p_id;
68: l_okc_k_sales_credits_pk okc_k_sales_credits_pk_csr%ROWTYPE;
69: l_scr_rec scr_rec_type;
70: BEGIN
71: x_no_data_found := TRUE;

Line 68: l_okc_k_sales_credits_pk okc_k_sales_credits_pk_csr%ROWTYPE;

64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE
66: FROM Okc_K_Sales_Credits
67: WHERE okc_k_sales_credits.id = p_id;
68: l_okc_k_sales_credits_pk okc_k_sales_credits_pk_csr%ROWTYPE;
69: l_scr_rec scr_rec_type;
70: BEGIN
71: x_no_data_found := TRUE;
72: -- Get current database values

Line 73: OPEN okc_k_sales_credits_pk_csr (p_scr_rec.id);

69: l_scr_rec scr_rec_type;
70: BEGIN
71: x_no_data_found := TRUE;
72: -- Get current database values
73: OPEN okc_k_sales_credits_pk_csr (p_scr_rec.id);
74: FETCH okc_k_sales_credits_pk_csr INTO
75: l_scr_rec.ID,
76: l_scr_rec.PERCENT,
77:

Line 74: FETCH okc_k_sales_credits_pk_csr INTO

70: BEGIN
71: x_no_data_found := TRUE;
72: -- Get current database values
73: OPEN okc_k_sales_credits_pk_csr (p_scr_rec.id);
74: FETCH okc_k_sales_credits_pk_csr INTO
75: l_scr_rec.ID,
76: l_scr_rec.PERCENT,
77:
78: l_scr_rec.CHR_ID,

Line 95: x_no_data_found := okc_k_sales_credits_pk_csr%NOTFOUND;

91: l_scr_rec.CREATED_BY,
92: l_scr_rec.CREATION_DATE,
93: l_scr_rec.LAST_UPDATED_BY,
94: l_scr_rec.LAST_UPDATE_DATE;
95: x_no_data_found := okc_k_sales_credits_pk_csr%NOTFOUND;
96: CLOSE okc_k_sales_credits_pk_csr;
97: RETURN(l_scr_rec);
98: END get_rec;
99:

Line 96: CLOSE okc_k_sales_credits_pk_csr;

92: l_scr_rec.CREATION_DATE,
93: l_scr_rec.LAST_UPDATED_BY,
94: l_scr_rec.LAST_UPDATE_DATE;
95: x_no_data_found := okc_k_sales_credits_pk_csr%NOTFOUND;
96: CLOSE okc_k_sales_credits_pk_csr;
97: RETURN(l_scr_rec);
98: END get_rec;
99:
100: FUNCTION get_rec (

Line 108: -- FUNCTION get_rec for: OKC_K_SALES_CREDITS_V

104: BEGIN
105: RETURN(get_rec(p_scr_rec, l_row_notfound));
106: END get_rec;
107: ---------------------------------------------------------------------------
108: -- FUNCTION get_rec for: OKC_K_SALES_CREDITS_V
109: ---------------------------------------------------------------------------
110: FUNCTION get_rec (
111: p_scrv_rec IN scrv_rec_type,
112: x_no_data_found OUT NOCOPY BOOLEAN

Line 136: FROM Okc_K_Sales_Credits

132: CREATED_BY,
133: CREATION_DATE,
134: LAST_UPDATED_BY,
135: LAST_UPDATE_DATE
136: FROM Okc_K_Sales_Credits
137: WHERE okc_k_sales_credits.id = p_id;
138: l_scrv_pk okc_scrv_csr%ROWTYPE;
139: l_scrv_rec scrv_rec_type;
140: BEGIN

Line 137: WHERE okc_k_sales_credits.id = p_id;

133: CREATION_DATE,
134: LAST_UPDATED_BY,
135: LAST_UPDATE_DATE
136: FROM Okc_K_Sales_Credits
137: WHERE okc_k_sales_credits.id = p_id;
138: l_scrv_pk okc_scrv_csr%ROWTYPE;
139: l_scrv_rec scrv_rec_type;
140: BEGIN
141: x_no_data_found := TRUE;

Line 182: -- FUNCTION null_out_defaults for: OKC_K_SALES_CREDITS_V --

178: RETURN(get_rec(p_scrv_rec, l_row_notfound));
179: END get_rec;
180:
181: -----------------------------------------------------------
182: -- FUNCTION null_out_defaults for: OKC_K_SALES_CREDITS_V --
183: -----------------------------------------------------------
184: FUNCTION null_out_defaults (
185: p_scrv_rec IN scrv_rec_type
186: ) RETURN scrv_rec_type IS

Line 243: -- Validate_Attributes for:OKC_K_SALES_CREDITS_V --

239: ---------------------------------------------------------------------------
240: -- PROCEDURE Validate_Attributes
241: ---------------------------------------------------------------------------
242: ---------------------------------------------------
243: -- Validate_Attributes for:OKC_K_SALES_CREDITS_V --
244: ---------------------------------------------------
245: -----------------------------------------------------
246: -- Validate ID--
247: -----------------------------------------------------

Line 528: -- Validate_Attributes for:OKC_K_SALES_CREDITS_V --

524: END validate_SALES_CREDIT_Type_Id2;
525:
526:
527: ---------------------------------------------------
528: -- Validate_Attributes for:OKC_K_SALES_CREDITS_V --
529: ---------------------------------------------------
530: FUNCTION Validate_Attributes (
531: p_scrv_rec IN scrv_rec_type
532: )

Line 541: OKC_UTIL.ADD_VIEW('OKC_K_SALES_CREDITS_V',x_return_status);

537: Begin
538:
539: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
540:
541: OKC_UTIL.ADD_VIEW('OKC_K_SALES_CREDITS_V',x_return_status);
542:
543: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: -- need to leave

Line 680: -- Validate_Record for:OKC_K_SALES_CREDITS_V --

676:
677: END validate_attributes;
678:
679: -----------------------------------------------
680: -- Validate_Record for:OKC_K_SALES_CREDITS_V --
681: -----------------------------------------------
682: FUNCTION Validate_Record (
683: p_scrv_rec IN scrv_rec_type
684: ) RETURN VARCHAR2 IS

Line 751: -- validate_row for:OKC_K_SALES_CREDITS_V --

747: ---------------------------------------------------------------------------
748: -- PROCEDURE validate_row
749: ---------------------------------------------------------------------------
750: --------------------------------------------
751: -- validate_row for:OKC_K_SALES_CREDITS_V --
752: --------------------------------------------
753: PROCEDURE validate_row(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 ,

Line 827: -- PL/SQL TBL validate_row for:OKC_K_SALES_CREDITS_V_TBL --

823: '_PVT'
824: );
825: END validate_row;
826: -----------------------------------------------------------
827: -- PL/SQL TBL validate_row for:OKC_K_SALES_CREDITS_V_TBL --
828: -----------------------------------------------------------
829: PROCEDURE validate_row(
830: p_api_version IN NUMBER,
831: p_init_msg_list IN VARCHAR2 ,

Line 901: INSERT INTO okc_k_sales_credits_h

897:
898: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
899:
900: BEGIN
901: INSERT INTO okc_k_sales_credits_h
902: (
903: major_version,
904: id,
905: dnz_chr_id,

Line 936: FROM okc_k_sales_credits

932: created_by,
933: creation_date,
934: last_updated_by,
935: last_update_date
936: FROM okc_k_sales_credits
937: WHERE dnz_chr_id = p_chr_id;
938:
939: RETURN l_return_status;
940: EXCEPTION

Line 968: INSERT INTO okc_k_sales_credits

964:
965:
966: BEGIN
967:
968: INSERT INTO okc_k_sales_credits
969: (
970: id,
971: dnz_chr_id,
972: percent,

Line 1001: FROM okc_k_sales_credits_h

997: created_by,
998: creation_date,
999: last_updated_by,
1000: last_update_date
1001: FROM okc_k_sales_credits_h
1002: WHERE dnz_chr_id = p_chr_id
1003: AND major_version = p_major_version;
1004:
1005:

Line 1029: -- insert_row for:OKC_K_SALES_CREDITS --

1025: ---------------------------------------------------------------------------
1026: -- PROCEDURE insert_row
1027: ---------------------------------------------------------------------------
1028: ----------------------------------------
1029: -- insert_row for:OKC_K_SALES_CREDITS --
1030: ----------------------------------------
1031: PROCEDURE insert_row(
1032: p_init_msg_list IN VARCHAR2 ,
1033: x_return_status OUT NOCOPY VARCHAR2,

Line 1045: -- Set_Attributes for:OKC_K_SALES_CREDITS --

1041: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1042: l_scr_rec scr_rec_type := p_scr_rec;
1043: l_def_scr_rec scr_rec_type;
1044: --------------------------------------------
1045: -- Set_Attributes for:OKC_K_SALES_CREDITS --
1046: --------------------------------------------
1047: FUNCTION Set_Attributes (
1048: p_scr_rec IN scr_rec_type,
1049: x_scr_rec OUT NOCOPY scr_rec_type

Line 1081: INSERT INTO OKC_K_SALES_CREDITS(

1077: END IF;
1078:
1079: l_scr_rec.id := get_seq_id;
1080:
1081: INSERT INTO OKC_K_SALES_CREDITS(
1082: id,
1083: percent,
1084:
1085: chr_id,

Line 1160: -- insert_row for:OKC_K_SALES_CREDITS_V --

1156: '_PVT'
1157: );
1158: END insert_row;
1159: ------------------------------------------
1160: -- insert_row for:OKC_K_SALES_CREDITS_V --
1161: ------------------------------------------
1162: PROCEDURE insert_row(
1163: p_api_version IN NUMBER,
1164: p_init_msg_list IN VARCHAR2 ,

Line 1193: -- Set_Attributes for:OKC_K_SALES_CREDITS_V --

1189: l_scrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1190: RETURN(l_scrv_rec);
1191: END fill_who_columns;
1192: ----------------------------------------------
1193: -- Set_Attributes for:OKC_K_SALES_CREDITS_V --
1194: ----------------------------------------------
1195: FUNCTION Set_Attributes (
1196: p_scrv_rec IN scrv_rec_type,
1197: x_scrv_rec OUT NOCOPY scrv_rec_type

Line 1305: -- PL/SQL TBL insert_row for:OKC_K_SALES_CREDITS_V_TBL --

1301: '_PVT'
1302: );
1303: END insert_row;
1304: ---------------------------------------------------------
1305: -- PL/SQL TBL insert_row for:OKC_K_SALES_CREDITS_V_TBL --
1306: ---------------------------------------------------------
1307: PROCEDURE insert_row(
1308: p_api_version IN NUMBER,
1309: p_init_msg_list IN VARCHAR2 ,

Line 1375: -- lock_row for:OKC_K_SALES_CREDITS --

1371: ---------------------------------------------------------------------------
1372: -- PROCEDURE lock_row
1373: ---------------------------------------------------------------------------
1374: --------------------------------------
1375: -- lock_row for:OKC_K_SALES_CREDITS --
1376: --------------------------------------
1377: PROCEDURE lock_row(
1378: p_init_msg_list IN VARCHAR2 ,
1379: x_return_status OUT NOCOPY VARCHAR2,

Line 1388: FROM OKC_K_SALES_CREDITS

1384: E_Resource_Busy EXCEPTION;
1385: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1386: CURSOR lock_csr (p_scr_rec IN scr_rec_type) IS
1387: SELECT OBJECT_VERSION_NUMBER
1388: FROM OKC_K_SALES_CREDITS
1389: WHERE ID = p_scr_rec.id
1390: AND OBJECT_VERSION_NUMBER = p_scr_rec.object_version_number
1391: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1392:

Line 1395: FROM OKc_K_SALES_CREDITS

1391: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1392:
1393: CURSOR lchk_csr (p_scr_rec IN scr_rec_type) IS
1394: SELECT OBJECT_VERSION_NUMBER
1395: FROM OKc_K_SALES_CREDITS
1396: WHERE ID = p_scr_rec.id;
1397: l_api_version CONSTANT NUMBER := 1;
1398: l_api_name CONSTANT VARCHAR2(30) := 'CREDITS_lock_row';
1399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1400: l_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;

1396: WHERE ID = p_scr_rec.id;
1397: l_api_version CONSTANT NUMBER := 1;
1398: l_api_name CONSTANT VARCHAR2(30) := 'CREDITS_lock_row';
1399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1400: l_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;
1401: lc_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;
1402: l_row_notfound BOOLEAN := FALSE;
1403: lc_row_notfound BOOLEAN := FALSE;
1404: BEGIN

Line 1401: lc_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;

1397: l_api_version CONSTANT NUMBER := 1;
1398: l_api_name CONSTANT VARCHAR2(30) := 'CREDITS_lock_row';
1399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1400: l_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;
1401: lc_object_version_number OKC_K_SALES_CREDITS.OBJECT_VERSION_NUMBER%TYPE;
1402: l_row_notfound BOOLEAN := FALSE;
1403: lc_row_notfound BOOLEAN := FALSE;
1404: BEGIN
1405: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1481: -- lock_row for:OKC_K_SALES_CREDITS_V --

1477: '_PVT'
1478: );
1479: END lock_row;
1480: ----------------------------------------
1481: -- lock_row for:OKC_K_SALES_CREDITS_V --
1482: ----------------------------------------
1483: PROCEDURE lock_row(
1484: p_api_version IN NUMBER,
1485: p_init_msg_list IN VARCHAR2 ,

Line 1561: -- PL/SQL TBL lock_row for:OKC_K_SALES_CREDITS_V_TBL --

1557: '_PVT'
1558: );
1559: END lock_row;
1560: -------------------------------------------------------
1561: -- PL/SQL TBL lock_row for:OKC_K_SALES_CREDITS_V_TBL --
1562: -------------------------------------------------------
1563: PROCEDURE lock_row(
1564: p_api_version IN NUMBER,
1565: p_init_msg_list IN VARCHAR2 ,

Line 1629: -- update_row for:OKC_K_SALES_CREDITS --

1625: ---------------------------------------------------------------------------
1626: -- PROCEDURE update_row
1627: ---------------------------------------------------------------------------
1628: ----------------------------------------
1629: -- update_row for:OKC_K_SALES_CREDITS --
1630: ----------------------------------------
1631: PROCEDURE update_row(
1632: p_init_msg_list IN VARCHAR2 ,
1633: x_return_status OUT NOCOPY VARCHAR2,

Line 1732: -- Set_Attributes for:OKC_K_SALES_CREDITS --

1728: END IF;
1729: RETURN(l_return_status);
1730: END populate_new_record;
1731: --------------------------------------------
1732: -- Set_Attributes for:OKC_K_SALES_CREDITS --
1733: --------------------------------------------
1734: FUNCTION Set_Attributes (
1735: p_scr_rec IN scr_rec_type,
1736: x_scr_rec OUT NOCOPY scr_rec_type

Line 1769: UPDATE OKC_K_SALES_CREDITS

1765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_ERROR;
1768: END IF;
1769: UPDATE OKC_K_SALES_CREDITS
1770: SET PERCENT = l_def_scr_rec.percent,
1771:
1772: CHR_ID = l_def_scr_rec.chr_id,
1773: DNZ_CHR_ID = l_def_scr_rec.dnz_chr_id,

Line 1826: -- update_row for:OKC_K_SALES_CREDITS_V --

1822: '_PVT'
1823: );
1824: END update_row;
1825: ------------------------------------------
1826: -- update_row for:OKC_K_SALES_CREDITS_V --
1827: ------------------------------------------
1828: PROCEDURE update_row(
1829: p_api_version IN NUMBER,
1830: p_init_msg_list IN VARCHAR2 ,

Line 1942: -- Set_Attributes for:OKC_K_SALES_CREDITS_V --

1938: END IF;
1939: RETURN(l_return_status);
1940: END populate_new_record;
1941: ----------------------------------------------
1942: -- Set_Attributes for:OKC_K_SALES_CREDITS_V --
1943: ----------------------------------------------
1944: FUNCTION Set_Attributes (
1945: p_scrv_rec IN scrv_rec_type,
1946: x_scrv_rec OUT NOCOPY scrv_rec_type

Line 2055: -- PL/SQL TBL update_row for:OKC_K_SALES_CREDITS_V_TBL --

2051: '_PVT'
2052: );
2053: END update_row;
2054: ---------------------------------------------------------
2055: -- PL/SQL TBL update_row for:OKC_K_SALES_CREDITS_V_TBL --
2056: ---------------------------------------------------------
2057: PROCEDURE update_row(
2058: p_api_version IN NUMBER,
2059: p_init_msg_list IN VARCHAR2 ,

Line 2125: -- delete_row for:OKC_K_SALES_CREDITS --

2121: ---------------------------------------------------------------------------
2122: -- PROCEDURE delete_row
2123: ---------------------------------------------------------------------------
2124: ----------------------------------------
2125: -- delete_row for:OKC_K_SALES_CREDITS --
2126: ----------------------------------------
2127: PROCEDURE delete_row(
2128: p_init_msg_list IN VARCHAR2 ,
2129: x_return_status OUT NOCOPY VARCHAR2,

Line 2150: DELETE FROM OKC_K_SALES_CREDITS

2146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;
2149:
2150: DELETE FROM OKC_K_SALES_CREDITS
2151: WHERE ID = l_scr_rec.id;
2152:
2153: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2154: EXCEPTION

Line 2187: -- delete_row for:OKC_K_SALES_CREDITS_V --

2183: '_PVT'
2184: );
2185: END delete_row;
2186: ------------------------------------------
2187: -- delete_row for:OKC_K_SALES_CREDITS_V --
2188: ------------------------------------------
2189: PROCEDURE delete_row(
2190: p_api_version IN NUMBER,
2191: p_init_msg_list IN VARCHAR2 ,

Line 2268: -- PL/SQL TBL delete_row for:OKC_K_SALES_CREDITS_V_TBL --

2264: '_PVT'
2265: );
2266: END delete_row;
2267: ---------------------------------------------------------
2268: -- PL/SQL TBL delete_row for:OKC_K_SALES_CREDITS_V_TBL --
2269: ---------------------------------------------------------
2270: PROCEDURE delete_row(
2271: p_api_version IN NUMBER,
2272: p_init_msg_list IN VARCHAR2 ,