DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on OKC_K_HEADERS_V

Line 18: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_HEADERS_V';

14: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
18: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_HEADERS_V';
19: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
21:
22: -- Start of comments

Line 2994: -- FUNCTION get_rec for: OKC_K_HEADERS_V

2990: RETURN(get_rec(p_okc_k_headers_tl_rec, l_row_notfound));
2991:
2992: END get_rec;
2993: ---------------------------------------------------------------------------
2994: -- FUNCTION get_rec for: OKC_K_HEADERS_V
2995: ---------------------------------------------------------------------------
2996: FUNCTION get_rec (
2997: p_chrv_rec IN chrv_rec_type,
2998: x_no_data_found OUT NOCOPY BOOLEAN

Line 3111: FROM Okc_K_Headers_V

3107: PAYMENT_INSTRUCTION_TYPE,
3108: ORG_ID, --mmadhavi added for MOAC
3109: CANCELLED_AMOUNT -- LLC
3110: -- R12 Data Model Changes 4485150 End
3111: FROM Okc_K_Headers_V
3112: WHERE okc_k_headers_v.id = p_id;
3113: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
3114: l_chrv_rec chrv_rec_type;
3115: BEGIN

Line 3112: WHERE okc_k_headers_v.id = p_id;

3108: ORG_ID, --mmadhavi added for MOAC
3109: CANCELLED_AMOUNT -- LLC
3110: -- R12 Data Model Changes 4485150 End
3111: FROM Okc_K_Headers_V
3112: WHERE okc_k_headers_v.id = p_id;
3113: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
3114: l_chrv_rec chrv_rec_type;
3115: BEGIN
3116:

Line 3260: -- FUNCTION null_out_defaults for: OKC_K_HEADERS_V --

3256:
3257: END get_rec;
3258:
3259: -----------------------------------------------------
3260: -- FUNCTION null_out_defaults for: OKC_K_HEADERS_V --
3261: -----------------------------------------------------
3262: FUNCTION null_out_defaults (
3263: p_chrv_rec IN chrv_rec_type
3264: ) RETURN chrv_rec_type IS

Line 3603: -- Validate_Attributes for:OKC_K_HEADERS_V --

3599: ---------------------------------------------------------------------------
3600: -- PROCEDURE Validate_Attributes
3601: ---------------------------------------------------------------------------
3602: ---------------------------------------------
3603: -- Validate_Attributes for:OKC_K_HEADERS_V --
3604: ---------------------------------------------
3605: FUNCTION Validate_Attributes (
3606: p_chrv_rec IN chrv_rec_type
3607: ) RETURN VARCHAR2 IS

Line 4112: -- Validate_Record for:OKC_K_HEADERS_V --

4108: -- PROCEDURE Validate_Record
4109: ---------------------------------------------------------------------------
4110:
4111: -----------------------------------------
4112: -- Validate_Record for:OKC_K_HEADERS_V --
4113: -----------------------------------------
4114: FUNCTION Validate_Record (
4115: p_chrv_rec IN chrv_rec_type
4116: ) RETURN VARCHAR2 IS

Line 4530: -- validate_row for:OKC_K_HEADERS_V --

4526: ---------------------------------------------------------------------------
4527: -- PROCEDURE validate_row
4528: ---------------------------------------------------------------------------
4529: --------------------------------------
4530: -- validate_row for:OKC_K_HEADERS_V --
4531: --------------------------------------
4532: PROCEDURE validate_row(
4533: p_api_version IN NUMBER,
4534: p_init_msg_list IN VARCHAR2,

Line 5244: -- insert_row for:OKC_K_HEADERS_V --

5240: );
5241:
5242: END insert_row;
5243: ------------------------------------
5244: -- insert_row for:OKC_K_HEADERS_V --
5245: ------------------------------------
5246: PROCEDURE insert_row(
5247: p_api_version IN NUMBER,
5248: p_init_msg_list IN VARCHAR2,

Line 5287: -- Set_Attributes for:OKC_K_HEADERS_V --

5283: RETURN(l_chrv_rec);
5284:
5285: END fill_who_columns;
5286: ----------------------------------------
5287: -- Set_Attributes for:OKC_K_HEADERS_V --
5288: ----------------------------------------
5289: FUNCTION Set_Attributes (
5290: p_chrv_rec IN chrv_rec_type,
5291: x_chrv_rec OUT NOCOPY chrv_rec_type

Line 5911: -- lock_row for:OKC_K_HEADERS_V --

5907: );
5908:
5909: END lock_row;
5910: ----------------------------------
5911: -- lock_row for:OKC_K_HEADERS_V --
5912: ----------------------------------
5913: PROCEDURE lock_row(
5914: p_api_version IN NUMBER,
5915: p_init_msg_list IN VARCHAR2,

Line 7023: -- update_row for:OKC_K_HEADERS_V --

7019: );
7020:
7021: END update_row;
7022: ------------------------------------
7023: -- update_row for:OKC_K_HEADERS_V --
7024: ------------------------------------
7025: PROCEDURE update_row(
7026: p_api_version IN NUMBER,
7027: p_init_msg_list IN VARCHAR2,

Line 7505: -- Set_Attributes for:OKC_K_HEADERS_V --

7501: RETURN(l_return_status);
7502:
7503: END populate_new_record;
7504: ----------------------------------------
7505: -- Set_Attributes for:OKC_K_HEADERS_V --
7506: ----------------------------------------
7507: FUNCTION Set_Attributes (
7508: p_chrv_rec IN chrv_rec_type,
7509: x_chrv_rec OUT NOCOPY chrv_rec_type

Line 8025: -- delete_row for:OKC_K_HEADERS_V --

8021: );
8022:
8023: END delete_row;
8024: ------------------------------------
8025: -- delete_row for:OKC_K_HEADERS_V --
8026: ------------------------------------
8027: PROCEDURE delete_row(
8028: p_api_version IN NUMBER,
8029: p_init_msg_list IN VARCHAR2,