DBA Data[Home] [Help]

APPS.OKS_KHR_PVT dependencies on OKS_K_HEADERS_V

Line 94: -- FUNCTION get_rec for: OKS_K_HEADERS_V

90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_K_HEADERS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_khrv_rec IN khrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 188: FROM Oks_K_Headers_V

184: TAX_CLASSIFICATION_CODE,
185: EXEMPT_CERTIFICATE_NUMBER,
186: EXEMPT_REASON_CODE,
187: APPROVAL_TYPE_USED
188: FROM Oks_K_Headers_V
189: WHERE oks_k_headers_v.id = p_id;
190: l_oks_khrv_pk oks_khrv_pk_csr%ROWTYPE;
191: l_khrv_rec khrv_rec_type;
192: BEGIN

Line 189: WHERE oks_k_headers_v.id = p_id;

185: EXEMPT_CERTIFICATE_NUMBER,
186: EXEMPT_REASON_CODE,
187: APPROVAL_TYPE_USED
188: FROM Oks_K_Headers_V
189: WHERE oks_k_headers_v.id = p_id;
190: l_oks_khrv_pk oks_khrv_pk_csr%ROWTYPE;
191: l_khrv_rec khrv_rec_type;
192: BEGIN
193: x_no_data_found := TRUE;

Line 538: -- FUNCTION null_out_defaults for: OKS_K_HEADERS_V

534: BEGIN
535: RETURN(get_rec(p_khr_rec, l_row_not_found));
536: END get_rec;
537: ---------------------------------------------------------------------------
538: -- FUNCTION null_out_defaults for: OKS_K_HEADERS_V
539: ---------------------------------------------------------------------------
540: FUNCTION null_out_defaults (
541: p_khrv_rec IN khrv_rec_type
542: ) RETURN khrv_rec_type IS

Line 890: -- Validate_Attributes for:OKS_K_HEADERS_V --

886: ---------------------------------------------------------------------------
887: -- FUNCTION Validate_Attributes
888: ---------------------------------------------------------------------------
889: ---------------------------------------------
890: -- Validate_Attributes for:OKS_K_HEADERS_V --
891: ---------------------------------------------
892: FUNCTION Validate_Attributes (
893: p_khrv_rec IN khrv_rec_type
894: ) RETURN VARCHAR2 IS

Line 946: -- Validate Record for:OKS_K_HEADERS_V --

942: ---------------------------------------------------------------------------
943: -- PROCEDURE Validate_Record
944: ---------------------------------------------------------------------------
945: -----------------------------------------
946: -- Validate Record for:OKS_K_HEADERS_V --
947: -----------------------------------------
948: FUNCTION Validate_Record (
949: p_khrv_rec IN khrv_rec_type,
950: p_db_khrv_rec IN khrv_rec_type

Line 1193: -- validate_row for:OKS_K_HEADERS_V --

1189: ---------------------------------------------------------------------------
1190: -- PROCEDURE validate_row
1191: ---------------------------------------------------------------------------
1192: --------------------------------------
1193: -- validate_row for:OKS_K_HEADERS_V --
1194: --------------------------------------
1195: PROCEDURE validate_row(
1196: p_api_version IN NUMBER,
1197: p_init_msg_list IN VARCHAR2,

Line 1270: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --

1266: '_PVT'
1267: );
1268: END validate_row;
1269: -------------------------------------------------
1270: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --
1271: -------------------------------------------------
1272: PROCEDURE validate_row(
1273: p_api_version IN NUMBER,
1274: p_init_msg_list IN VARCHAR2,

Line 1366: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --

1362: );
1363: END validate_row;
1364:
1365: -------------------------------------------------
1366: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --
1367: -------------------------------------------------
1368: PROCEDURE validate_row(
1369: p_api_version IN NUMBER,
1370: p_init_msg_list IN VARCHAR2,

Line 1793: -- insert_row for :OKS_K_HEADERS_V --

1789: '_PVT'
1790: );
1791: END insert_row;
1792: -------------------------------------
1793: -- insert_row for :OKS_K_HEADERS_V --
1794: -------------------------------------
1795: PROCEDURE insert_row(
1796: p_api_version IN NUMBER,
1797: p_init_msg_list IN VARCHAR2,

Line 1827: -- Set_Attributes for:OKS_K_HEADERS_V --

1823: l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1824: RETURN(l_khrv_rec);
1825: END fill_who_columns;
1826: ----------------------------------------
1827: -- Set_Attributes for:OKS_K_HEADERS_V --
1828: ----------------------------------------
1829: FUNCTION Set_Attributes (
1830: p_khrv_rec IN khrv_rec_type,
1831: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 2212: -- lock_row for: OKS_K_HEADERS_V --

2208: '_PVT'
2209: );
2210: END lock_row;
2211: -----------------------------------
2212: -- lock_row for: OKS_K_HEADERS_V --
2213: -----------------------------------
2214: PROCEDURE lock_row(
2215: p_api_version IN NUMBER,
2216: p_init_msg_list IN VARCHAR2,

Line 3120: -- update_row for:OKS_K_HEADERS_V --

3116: '_PVT'
3117: );
3118: END update_row;
3119: ------------------------------------
3120: -- update_row for:OKS_K_HEADERS_V --
3121: ------------------------------------
3122: PROCEDURE update_row(
3123: p_api_version IN NUMBER,
3124: p_init_msg_list IN VARCHAR2,

Line 3512: -- Set_Attributes for:OKS_K_HEADERS_V --

3508: END IF;
3509: RETURN(l_return_status);
3510: END populate_new_record;
3511: ----------------------------------------
3512: -- Set_Attributes for:OKS_K_HEADERS_V --
3513: ----------------------------------------
3514: FUNCTION Set_Attributes (
3515: p_khrv_rec IN khrv_rec_type,
3516: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 3906: -- delete_row for:OKS_K_HEADERS_V --

3902: '_PVT'
3903: );
3904: END delete_row;
3905: ------------------------------------
3906: -- delete_row for:OKS_K_HEADERS_V --
3907: ------------------------------------
3908: PROCEDURE delete_row(
3909: p_api_version IN NUMBER,
3910: p_init_msg_list IN VARCHAR2,

Line 3988: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --

3984: '_PVT'
3985: );
3986: END delete_row;
3987: -----------------------------------------------
3988: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --
3989: -----------------------------------------------
3990: PROCEDURE delete_row(
3991: p_api_version IN NUMBER,
3992: p_init_msg_list IN VARCHAR2,

Line 4084: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --

4080: );
4081: END delete_row;
4082:
4083: -----------------------------------------------
4084: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --
4085: -----------------------------------------------
4086: PROCEDURE delete_row(
4087: p_api_version IN NUMBER,
4088: p_init_msg_list IN VARCHAR2,