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_CHR_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 299: FROM OKC_K_HEADERS_ALL_B

295: SELECT 'x'
296: --npalepu 08-11-2005 modified for bug # 4691662.
297: --Replaced table okc_k_headers_b with headers_All_b table
298: /* FROM OKC_K_HEADERS_B */
299: FROM OKC_K_HEADERS_ALL_B
300: --end npalepu
301: WHERE id = p_chrv_rec.chr_id_response;
302:
303: BEGIN

Line 383: FROM OKC_K_HEADERS_ALL_B

379: SELECT 'x'
380: --npalepu 08-11-2005 modified for bug # 4691662.
381: --Replaced table okc_k_headers_b with headers_All_b table
382: /* FROM OKC_K_HEADERS_B */
383: FROM OKC_K_HEADERS_ALL_B
384: --end npalepu
385: WHERE id = p_chrv_rec.chr_id_award;
386:
387: BEGIN

Line 2665: -- FUNCTION get_rec for: OKC_K_HEADERS_ALL_B

2661:
2662: END add_language;
2663:
2664: ---------------------------------------------------------------------------
2665: -- FUNCTION get_rec for: OKC_K_HEADERS_ALL_B
2666: ---------------------------------------------------------------------------
2667: FUNCTION get_rec (
2668: p_chr_rec IN chr_rec_type,
2669: x_no_data_found OUT NOCOPY BOOLEAN

Line 2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC

2771: PAYMENT_INSTRUCTION_TYPE,
2772: ORG_ID, --mmadhavi added for MOAC
2773: -- R12 Data Model Changes 4485150 End
2774: CANCELLED_AMOUNT -- LLC
2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC
2776: WHERE okc_k_headers_all_b.id = p_id;
2777: l_chr_pk chr_pk_csr%ROWTYPE;
2778: l_chr_rec chr_rec_type;
2779: BEGIN

Line 2776: WHERE okc_k_headers_all_b.id = p_id;

2772: ORG_ID, --mmadhavi added for MOAC
2773: -- R12 Data Model Changes 4485150 End
2774: CANCELLED_AMOUNT -- LLC
2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC
2776: WHERE okc_k_headers_all_b.id = p_id;
2777: l_chr_pk chr_pk_csr%ROWTYPE;
2778: l_chr_rec chr_rec_type;
2779: BEGIN
2780:

Line 4037: FROM okc_k_headers_all_b

4033: SELECT 'x'
4034: --npalepu 08-11-2005 modified for bug # 4691662.
4035: --Replaced table okc_k_headers_b with headers_All_b table
4036: /* FROM okc_k_headers_b */
4037: FROM okc_k_headers_all_b
4038: --end npalepu
4039: WHERE contract_number = p_chrv_rec.contract_number
4040: AND contract_number_modifier IS NULL
4041: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4048: FROM okc_k_headers_all_b

4044: SELECT 'x'
4045: --npalepu 08-11-2005 modified for bug # 4691662.
4046: --Replaced table okc_k_headers_b with headers_All_b table
4047: /* FROM okc_k_headers_b */
4048: FROM okc_k_headers_all_b
4049: --end npalepu
4050: WHERE contract_number = p_chrv_rec.contract_number
4051: AND contract_number_modifier = p_chrv_rec.contract_number_modifier
4052: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4122: FROM okc_k_headers_all_b

4118: SELECT 'x'
4119: --npalepu 08-11-2005 modified for bug # 4691662.
4120: --Replaced table okc_k_headers_b with headers_All_b table
4121: /* FROM okc_k_headers_b */
4122: FROM okc_k_headers_all_b
4123: --end npalepu
4124: WHERE contract_number = p_chrv_rec.contract_number
4125: AND contract_number_modifier IS NULL
4126: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4133: FROM okc_k_headers_all_b

4129: SELECT 'x'
4130: --npalepu 08-11-2005 modified for bug # 4691662.
4131: --Replaced table okc_k_headers_b with headers_All_b table
4132: /* FROM okc_k_headers_b */
4133: FROM okc_k_headers_all_b
4134: --end npalepu
4135: WHERE contract_number = p_chrv_rec.contract_number
4136: AND contract_number_modifier = p_chrv_rec.contract_number_modifier
4137: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4752: -- insert_row for:OKC_K_HEADERS_ALL_B --

4748: ---------------------------------------------------------------------------
4749: -- PROCEDURE insert_row
4750: ---------------------------------------------------------------------------
4751: ------------------------------------
4752: -- insert_row for:OKC_K_HEADERS_ALL_B --
4753: ------------------------------------
4754: PROCEDURE insert_row(
4755: p_init_msg_list IN VARCHAR2,
4756: x_return_status OUT NOCOPY VARCHAR2,

Line 4768: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --

4764: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4765: l_chr_rec chr_rec_type := p_chr_rec;
4766: l_def_chr_rec chr_rec_type;
4767: ----------------------------------------
4768: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --
4769: ----------------------------------------
4770: FUNCTION Set_Attributes (
4771: p_chr_rec IN chr_rec_type,
4772: x_chr_rec OUT NOCOPY chr_rec_type

Line 4812: INSERT INTO OKC_K_HEADERS_ALL_B( --mmadhavi changed to _ALL for MOAC

4808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4809: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4810: RAISE OKC_API.G_EXCEPTION_ERROR;
4811: END IF;
4812: INSERT INTO OKC_K_HEADERS_ALL_B( --mmadhavi changed to _ALL for MOAC
4813: id,
4814: contract_number,
4815: authoring_org_id,
4816: org_id, --mmadhavi added for MOAC

Line 5622: -- lock_row for:OKC_K_HEADERS_ALL_B --

5618: ---------------------------------------------------------------------------
5619: -- PROCEDURE lock_row
5620: ---------------------------------------------------------------------------
5621: ----------------------------------
5622: -- lock_row for:OKC_K_HEADERS_ALL_B --
5623: ----------------------------------
5624: PROCEDURE lock_row(
5625: p_init_msg_list IN VARCHAR2,
5626: x_return_status OUT NOCOPY VARCHAR2,

Line 5635: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

5631: E_Resource_Busy EXCEPTION;
5632: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5633: CURSOR lock_csr (p_chr_rec IN chr_rec_type) IS
5634: SELECT OBJECT_VERSION_NUMBER
5635: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
5636: WHERE ID = p_chr_rec.id
5637: AND OBJECT_VERSION_NUMBER = p_chr_rec.object_version_number
5638: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5639:

Line 5642: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

5638: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5639:
5640: CURSOR lchk_csr (p_chr_rec IN chr_rec_type) IS
5641: SELECT OBJECT_VERSION_NUMBER
5642: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
5643: WHERE ID = p_chr_rec.id;
5644: l_api_version CONSTANT NUMBER := 1;
5645: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5646: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6146: -- update_row for:OKC_K_HEADERS_ALL_B --

6142: ---------------------------------------------------------------------------
6143: -- PROCEDURE update_row
6144: ---------------------------------------------------------------------------
6145: ------------------------------------
6146: -- update_row for:OKC_K_HEADERS_ALL_B --
6147: ------------------------------------
6148: PROCEDURE update_row(
6149: p_init_msg_list IN VARCHAR2,
6150: x_return_status OUT NOCOPY VARCHAR2,

Line 6570: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --

6566: RETURN(l_return_status);
6567:
6568: END populate_new_record;
6569: ----------------------------------------
6570: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --
6571: ----------------------------------------
6572: FUNCTION Set_Attributes (
6573: p_chr_rec IN chr_rec_type,
6574: x_chr_rec OUT NOCOPY chr_rec_type

Line 6621: UPDATE OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

6617: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6618: RAISE OKC_API.G_EXCEPTION_ERROR;
6619: END IF;
6620:
6621: UPDATE OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
6622: SET CONTRACT_NUMBER = l_def_chr_rec.contract_number,
6623: --AUTHORING_ORG_ID = l_def_chr_rec.authoring_org_id,
6624: CONTRACT_NUMBER_MODIFIER = l_def_chr_rec.contract_number_modifier,
6625: CHR_ID_RESPONSE = l_def_chr_rec.chr_id_response,

Line 7811: -- delete_row for:OKC_K_HEADERS_ALL_B --

7807: ---------------------------------------------------------------------------
7808: -- PROCEDURE delete_row
7809: ---------------------------------------------------------------------------
7810: ------------------------------------
7811: -- delete_row for:OKC_K_HEADERS_ALL_B --
7812: ------------------------------------
7813: PROCEDURE delete_row(
7814: p_init_msg_list IN VARCHAR2,
7815: x_return_status OUT NOCOPY VARCHAR2,

Line 7841: DELETE FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

7837: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7838: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7839: RAISE OKC_API.G_EXCEPTION_ERROR;
7840: END IF;
7841: DELETE FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
7842: WHERE ID = l_chr_rec.id;
7843:
7844: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7845: IF (l_debug = 'Y') THEN

Line 8551: INTO OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

8547: END LOOP;
8548:
8549: FORALL i IN 1..l_tabsize
8550: INSERT
8551: INTO OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
8552: (
8553: id,
8554: -- GCHADHA --
8555: -- BUG 3941485 --

Line 8876: INSERT INTO okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC

8872: okc_debug.Set_Indentation('OKC_CHR_PVT');
8873: okc_debug.LOG('23700: Entered create_version', 2);
8874: END IF;
8875:
8876: INSERT INTO okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC
8877: (
8878: major_version,
8879: id,
8880: contract_number,

Line 9084: FROM okc_k_headers_all_b --mamdhavi changed to _ALL for MOAC

9080: term_cancel_source,
9081: payment_instruction_type,
9082: cancelled_amount -- LLC
9083: -- R12 Data Model Changes 4485150 End
9084: FROM okc_k_headers_all_b --mamdhavi changed to _ALL for MOAC
9085: WHERE id = p_chr_id;
9086:
9087: --------------------------------
9088: -- Versioning TL Table

Line 9225: INSERT INTO okc_k_headers_all_b --mmadhavi changed to _ALL for MOAC

9221: --------------------------------------
9222: -- Restore Base Table
9223: --------------------------------------
9224:
9225: INSERT INTO okc_k_headers_all_b --mmadhavi changed to _ALL for MOAC
9226: (
9227: id,
9228: contract_number,
9229: authoring_org_id,

Line 9430: FROM okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC

9426: term_cancel_source,
9427: payment_instruction_type,
9428: cancelled_amount -- LLC
9429: -- R12 data Model Changes 4485150 End
9430: FROM okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC
9431: WHERE id = p_chr_id
9432: AND major_version = p_major_version;
9433:
9434: RETURN l_return_status;