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.IGC_CC_INT_CC_REL_PUB dependencies on IGC_CC_HEADERS

Line 28: p_org_id IN igc_cc_headers.org_id%TYPE,

24: --
25: -- To fetch the release number.
26: --
27: PROCEDURE release_cc_num (
28: p_org_id IN igc_cc_headers.org_id%TYPE,
29: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
30: );
31:
32: --

Line 29: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE

25: -- To fetch the release number.
26: --
27: PROCEDURE release_cc_num (
28: p_org_id IN igc_cc_headers.org_id%TYPE,
29: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
30: );
31:
32: --
33: -- To fetch the release header Id.

Line 36: x_release_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE

32: --
33: -- To fetch the release header Id.
34: --
35: PROCEDURE release_cc_header_id (
36: x_release_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE
37: );
38:
39: --
40: -- To fetch the release account line Id.

Line 104: p_org_id IN igc_cc_headers.org_id%TYPE,

100: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
101: p_commit IN VARCHAR2 := fnd_api.g_false,
102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,

Line 105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,

101: p_commit IN VARCHAR2 := fnd_api.g_false,
102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,

Line 106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,

102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,

Line 109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,

105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,
111: p_login_id IN igc_cc_headers.last_update_login%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,

Line 110: p_user_id IN igc_cc_headers.created_by%TYPE,

106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,
111: p_login_id IN igc_cc_headers.last_update_login%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,

Line 111: p_login_id IN igc_cc_headers.last_update_login%TYPE,

107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,
108: p_invoice_amount IN ap_invoices_all.invoice_amount%TYPE,
109: p_vendor_id IN igc_cc_headers.vendor_id%TYPE,
110: p_user_id IN igc_cc_headers.created_by%TYPE,
111: p_login_id IN igc_cc_headers.last_update_login%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: x_release_num OUT NOCOPY igc_cc_headers.cc_num%TYPE

Line 115: x_release_num OUT NOCOPY igc_cc_headers.cc_num%TYPE

111: p_login_id IN igc_cc_headers.last_update_login%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: x_release_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
116: )
117: IS
118: l_api_name CONSTANT VARCHAR2 (30) := 'create_releases';
119: l_api_version CONSTANT NUMBER := 1.0;

Line 120: l_cc_headers_rec igc_cc_headers%ROWTYPE;

116: )
117: IS
118: l_api_name CONSTANT VARCHAR2 (30) := 'create_releases';
119: l_api_version CONSTANT NUMBER := 1.0;
120: l_cc_headers_rec igc_cc_headers%ROWTYPE;
121: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
122: l_cc_det_pf_lines_rec igc_cc_det_pf%ROWTYPE;
123: l_ap_invoice_lines_rec ap_invoices_all%ROWTYPE;
124: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;

Line 130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;

126: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
127: := 0;
128: l_cc_rel_func_total_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
129: := 0;
130: l_cc_currency_code igc_cc_headers.currency_code%TYPE;
131: l_ap_currency_code ap_invoices_all.invoice_currency_code%TYPE;
132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE

Line 136: l_release_cc_num igc_cc_headers.cc_num%TYPE;

132: l_ap_conversion_rate ap_invoices_all.exchange_rate%TYPE;
133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;
138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
139: l_release_cc_det_pf_line_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;
140: l_return_status VARCHAR2 (1);

Line 137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;

133: l_invoice_amount ap_invoices_all.invoice_amount%TYPE := 0;
134: l_acct_available_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE
135: := 0;
136: l_release_cc_num igc_cc_headers.cc_num%TYPE;
137: l_release_cc_header_id igc_cc_headers.cc_header_id%TYPE;
138: l_release_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
139: l_release_cc_det_pf_line_id igc_cc_det_pf.cc_det_pf_line_id%TYPE;
140: l_return_status VARCHAR2 (1);
141: l_msg_count NUMBER;

Line 159: FROM igc_cc_headers cc

155:
156: CURSOR c_cc_csr
157: IS
158: SELECT *
159: FROM igc_cc_headers cc
160: WHERE cc.cc_header_id = p_cover_cc_header_id
161: AND cc.org_id = p_org_id
162: AND cc.set_of_books_id = p_sob_id;
163:

Line 379: FROM igc_cc_headers cc

375:
376: BEGIN
377: SELECT cc.currency_code
378: INTO l_cc_currency_code
379: FROM igc_cc_headers cc
380: WHERE cc.cc_header_id = p_cover_cc_header_id;
381: EXCEPTION
382: WHEN NO_DATA_FOUND
383: THEN

Line 417: FROM igc_cc_acct_lines ccal, igc_cc_headers cchd

413:
414: BEGIN
415: SELECT SUM (NVL (ccal.cc_acct_func_amt, 0))
416: INTO l_cc_rel_func_total_amt
417: FROM igc_cc_acct_lines ccal, igc_cc_headers cchd
418: WHERE ccal.parent_header_id = p_cover_cc_header_id
419: AND ccal.cc_header_id = cchd.cc_header_id;
420: EXCEPTION
421: WHEN OTHERS

Line 550: igc_cc_headers_pkg.insert_row

546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF; -- CC Header Identification.
549:
550: igc_cc_headers_pkg.insert_row
551: (p_api_version => 1.0,
552: p_init_msg_list => fnd_api.g_false,
553: p_commit => fnd_api.g_false,
554: p_validation_level => fnd_api.g_valid_level_full,

Line 996: p_org_id IN igc_cc_headers.org_id%TYPE,

992: END IF;
993: END create_releases;
994:
995: PROCEDURE release_cc_num (
996: p_org_id IN igc_cc_headers.org_id%TYPE,
997: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
998: )
999: IS
1000: l_api_name CONSTANT VARCHAR2 (30) := 'release_cc_num';

Line 997: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE

993: END create_releases;
994:
995: PROCEDURE release_cc_num (
996: p_org_id IN igc_cc_headers.org_id%TYPE,
997: x_release_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
998: )
999: IS
1000: l_api_name CONSTANT VARCHAR2 (30) := 'release_cc_num';
1001: l_full_path VARCHAR2 (255);

Line 1062: x_release_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE

1058: RETURN;
1059: END release_cc_num;
1060:
1061: PROCEDURE release_cc_header_id (
1062: x_release_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE
1063: )
1064: IS
1065: l_api_name CONSTANT VARCHAR2 (30) := 'release_cc_header_id';
1066: l_full_path VARCHAR2 (255);

Line 1072: SELECT igc_cc_headers_s.NEXTVAL

1068: l_full_path := g_path || 'release_cc_header_id';
1069: x_release_cc_header_id := NULL;
1070:
1071: BEGIN
1072: SELECT igc_cc_headers_s.NEXTVAL
1073: INTO x_release_cc_header_id
1074: FROM DUAL;
1075: EXCEPTION
1076: WHEN NO_DATA_FOUND