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_OPEN_INTERFACE_PKG dependencies on IGC_CC_HEADERS

Line 32: g_cc_state igc_cc_headers.cc_state%TYPE;

28: -- g_cc_conf_encmbrnc_flag VARCHAR2(1);
29: g_sb_prov_encmbrnc_flag VARCHAR2(1);
30: g_sb_conf_encmbrnc_flag VARCHAR2(1);
31:
32: g_cc_state igc_cc_headers.cc_state%TYPE;
33: g_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
34:
35:
36: -- Bug 2871052, created the following PLSQL tables for inserting into

Line 33: g_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;

29: g_sb_prov_encmbrnc_flag VARCHAR2(1);
30: g_sb_conf_encmbrnc_flag VARCHAR2(1);
31:
32: g_cc_state igc_cc_headers.cc_state%TYPE;
33: g_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
34:
35:
36: -- Bug 2871052, created the following PLSQL tables for inserting into
37: -- the pa_bc_packets table.

Line 122: SELECT igc_cc_headers_s.nextval

118: PROCEDURE HEADER_INTERFACE_DERIVE
119: ( P_Header_Id OUT NOCOPY NUMBER)
120: IS
121: BEGIN
122: SELECT igc_cc_headers_s.nextval
123: INTO P_Header_Id FROM DUAL;
124: END;
125:
126: /***************************************************************************/

Line 200: FROM igc_cc_headers_interface ICALI1

196: ICALI.interface_acct_line_id
197: FROM igc_cc_acct_lines_interface ICALI
198: WHERE ICALI.batch_id = g_batch_Id
199: AND NOT EXISTS (SELECT ICALI1.interface_header_id
200: FROM igc_cc_headers_interface ICALI1
201: WHERE ICALI1.batch_id = g_batch_id
202: AND ICALI.interface_header_id = ICALI1.interface_header_id);
203:
204: CURSOR c_interface_orphan_det_pf IS

Line 210: FROM igc_cc_headers_interface ICHI,

206: ICDPI.interface_det_pf_line_id
207: FROM igc_cc_det_pf_interface ICDPI
208: WHERE ICDPI.batch_id = g_batch_id
209: AND NOT EXISTS (SELECT ICALI.interface_acct_line_id
210: FROM igc_cc_headers_interface ICHI,
211: igc_cc_acct_lines_interface ICALI
212: WHERE ICHI.batch_id = g_batch_id
213: AND ICHI.batch_id = ICALI.batch_id
214: AND ICHI.interface_header_id = ICALI.interface_header_id

Line 283: FROM igc_cc_headers cch, igc_cc_headers_interface cchi

279: BEGIN
280: IF P_Interface_Parent_Header_Id IS NOT NULL AND P_Parent_Header_Id IS NULL THEN
281: BEGIN
282: SELECT cch.cc_header_id INTO P_Parent_Header_Id
283: FROM igc_cc_headers cch, igc_cc_headers_interface cchi
284: WHERE cchi.interface_header_id = P_Interface_Parent_Header_Id
285: AND cchi.cc_num = cch.cc_num
286: AND cchi.org_id = cch.org_id;
287: EXCEPTION WHEN OTHERS THEN RAISE;

Line 456: p_cc_type IN igc_cc_headers.cc_type%TYPE,

452: /* Bug No : 6341012. p_interface_parent_header_id, p_cc_encmbrnc_status,p_sbc_enable_flag,p_cbc_enable_flag, are not used in this procedure*/
453: -- p_interface_parent_header_id IN NUMBER,
454: p_org_id IN NUMBER,
455: p_set_of_books_id IN NUMBER,
456: p_cc_type IN igc_cc_headers.cc_type%TYPE,
457: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
458: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
459: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
460: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 457: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

453: -- p_interface_parent_header_id IN NUMBER,
454: p_org_id IN NUMBER,
455: p_set_of_books_id IN NUMBER,
456: p_cc_type IN igc_cc_headers.cc_type%TYPE,
457: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
458: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
459: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
460: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
461: -- p_sbc_enable_flag IN VARCHAR2,

Line 463: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

459: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
460: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
461: -- p_sbc_enable_flag IN VARCHAR2,
462: -- p_cbc_enable_flag IN VARCHAR2,
463: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
464: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
465: p_x_error_status IN OUT NOCOPY VARCHAR2)
466: IS
467: l_error_message VARCHAR2(2000);

Line 464: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

460: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
461: -- p_sbc_enable_flag IN VARCHAR2,
462: -- p_cbc_enable_flag IN VARCHAR2,
463: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
464: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
465: p_x_error_status IN OUT NOCOPY VARCHAR2)
466: IS
467: l_error_message VARCHAR2(2000);
468: l_valid BOOLEAN := TRUE;

Line 545: FROM igc_cc_headers_interface

541: AND l_valid
542: THEN
543: SELECT MIN(cc_start_date)
544: INTO l_min_rel_start_date
545: FROM igc_cc_headers_interface
546: WHERE interface_parent_header_id = p_interface_header_id;
547:
548: -- Check Start date of cover < earliest release start date
549: IF NVL(l_min_rel_start_date, p_cc_start_date) < p_cc_start_date

Line 586: p_cc_type IN igc_cc_headers.cc_type%TYPE,

582: p_cbc_enable_flag,p_cbc_start_date are not used in this procedure*/
583: -- p_interface_parent_header_id IN NUMBER,
584: p_org_id IN NUMBER,
585: p_set_of_books_id IN NUMBER,
586: p_cc_type IN igc_cc_headers.cc_type%TYPE,
587: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
588: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
589: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
590: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 587: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

583: -- p_interface_parent_header_id IN NUMBER,
584: p_org_id IN NUMBER,
585: p_set_of_books_id IN NUMBER,
586: p_cc_type IN igc_cc_headers.cc_type%TYPE,
587: -- p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
588: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
589: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
590: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
591: -- p_sbc_enable_flag IN VARCHAR2,

Line 593: -- p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

589: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
590: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
591: -- p_sbc_enable_flag IN VARCHAR2,
592: -- p_cbc_enable_flag IN VARCHAR2,
593: -- p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
594: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
595: p_x_error_status IN OUT NOCOPY VARCHAR2)
596: IS
597: l_error_message VARCHAR2(2000);

Line 594: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

590: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
591: -- p_sbc_enable_flag IN VARCHAR2,
592: -- p_cbc_enable_flag IN VARCHAR2,
593: -- p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
594: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
595: p_x_error_status IN OUT NOCOPY VARCHAR2)
596: IS
597: l_error_message VARCHAR2(2000);
598: l_valid BOOLEAN := TRUE;

Line 613: FROM igc_cc_headers_interface

609: IF p_cc_type = 'C'
610: THEN
611: SELECT MAX(cc_end_date)
612: INTO l_max_rel_end_date
613: FROM igc_cc_headers_interface
614: WHERE interface_parent_header_id = p_interface_header_id;
615:
616: -- Check End date of cover > latest release end date
617: IF NVL(l_max_rel_end_date, p_cc_end_date) > p_cc_end_date

Line 649: p_cc_type IN igc_cc_headers.cc_type%TYPE,

645: p_interface_parent_header_id IN NUMBER,
646: p_interface_acct_line_id IN NUMBER,
647: p_org_id IN NUMBER,
648: p_set_of_books_id IN NUMBER,
649: p_cc_type IN igc_cc_headers.cc_type%TYPE,
650: p_cc_state IN igc_cc_headers.cc_state%TYPE,
651: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
652: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
653: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/

Line 650: p_cc_state IN igc_cc_headers.cc_state%TYPE,

646: p_interface_acct_line_id IN NUMBER,
647: p_org_id IN NUMBER,
648: p_set_of_books_id IN NUMBER,
649: p_cc_type IN igc_cc_headers.cc_type%TYPE,
650: p_cc_state IN igc_cc_headers.cc_state%TYPE,
651: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
652: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
653: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
654: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,

Line 651: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

647: p_org_id IN NUMBER,
648: p_set_of_books_id IN NUMBER,
649: p_cc_type IN igc_cc_headers.cc_type%TYPE,
650: p_cc_state IN igc_cc_headers.cc_state%TYPE,
651: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
652: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
653: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
654: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
655: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 652: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,

648: p_set_of_books_id IN NUMBER,
649: p_cc_type IN igc_cc_headers.cc_type%TYPE,
650: p_cc_state IN igc_cc_headers.cc_state%TYPE,
651: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
652: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
653: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
654: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
655: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
656: p_sbc_enable_flag IN VARCHAR2,

Line 658: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

654: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
655: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
656: p_sbc_enable_flag IN VARCHAR2,
657: p_cbc_enable_flag IN VARCHAR2,
658: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
659: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
660: p_cc_acct_date IN DATE,
661: p_x_error_status IN OUT NOCOPY VARCHAR2)
662: IS

Line 659: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

655: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
656: p_sbc_enable_flag IN VARCHAR2,
657: p_cbc_enable_flag IN VARCHAR2,
658: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
659: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
660: p_cc_acct_date IN DATE,
661: p_x_error_status IN OUT NOCOPY VARCHAR2)
662: IS
663: l_error_message VARCHAR2(2000);

Line 791: p_cc_type IN igc_cc_headers.cc_type%TYPE,

787: p_interface_header_id IN NUMBER,
788: p_interface_acct_Line_Id IN NUMBER,
789: p_org_id IN NUMBER,
790: p_set_of_books_id IN NUMBER,
791: p_cc_type IN igc_cc_headers.cc_type%TYPE,
792: p_cc_state IN igc_cc_headers.cc_state%TYPE,
793: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
794: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
795: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/

Line 792: p_cc_state IN igc_cc_headers.cc_state%TYPE,

788: p_interface_acct_Line_Id IN NUMBER,
789: p_org_id IN NUMBER,
790: p_set_of_books_id IN NUMBER,
791: p_cc_type IN igc_cc_headers.cc_type%TYPE,
792: p_cc_state IN igc_cc_headers.cc_state%TYPE,
793: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
794: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
795: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
796: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,

Line 793: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

789: p_org_id IN NUMBER,
790: p_set_of_books_id IN NUMBER,
791: p_cc_type IN igc_cc_headers.cc_type%TYPE,
792: p_cc_state IN igc_cc_headers.cc_state%TYPE,
793: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
794: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
795: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
796: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
797: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 794: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,

790: p_set_of_books_id IN NUMBER,
791: p_cc_type IN igc_cc_headers.cc_type%TYPE,
792: p_cc_state IN igc_cc_headers.cc_state%TYPE,
793: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
794: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
795: /* Bug No : 6341012. SLA uptake. Encumbrance_Type_IDs and cc_flags are not required*/
796: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
797: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
798: p_sbc_enable_flag IN VARCHAR2,

Line 800: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

796: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
797: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
798: p_sbc_enable_flag IN VARCHAR2,
799: p_cbc_enable_flag IN VARCHAR2,
800: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
801: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
802: p_cc_acct_date IN DATE,
803: p_cc_encmbrnc_acct_date IN DATE,
804: p_x_error_status IN OUT NOCOPY VARCHAR2)

Line 801: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

797: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
798: p_sbc_enable_flag IN VARCHAR2,
799: p_cbc_enable_flag IN VARCHAR2,
800: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
801: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
802: p_cc_acct_date IN DATE,
803: p_cc_encmbrnc_acct_date IN DATE,
804: p_x_error_status IN OUT NOCOPY VARCHAR2)
805: IS

Line 902: p_cc_type IN igc_cc_headers.cc_type%TYPE,

898: PROCEDURE validate_pf_date(
899: p_interface_header_id IN NUMBER,
900: p_org_id IN NUMBER,
901: p_set_of_books_id IN NUMBER,
902: p_cc_type IN igc_cc_headers.cc_type%TYPE,
903: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
904: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */
905: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
906: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 903: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

899: p_interface_header_id IN NUMBER,
900: p_org_id IN NUMBER,
901: p_set_of_books_id IN NUMBER,
902: p_cc_type IN igc_cc_headers.cc_type%TYPE,
903: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
904: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */
905: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
906: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
907: p_sbc_enable_flag IN VARCHAR2,

Line 913: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

909: p_interface_acct_line_id IN VARCHAR2,
910: p_interface_det_pf_id IN VARCHAR2,
911: p_interface_parent_det_pf_id IN NUMBER,
912: p_cc_det_pf_date IN DATE,
913: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
914: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
915: p_x_error_status IN OUT NOCOPY VARCHAR2)
916: IS
917: l_cover_cc_det_pf_date DATE;

Line 914: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

910: p_interface_det_pf_id IN VARCHAR2,
911: p_interface_parent_det_pf_id IN NUMBER,
912: p_cc_det_pf_date IN DATE,
913: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
914: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
915: p_x_error_status IN OUT NOCOPY VARCHAR2)
916: IS
917: l_cover_cc_det_pf_date DATE;
918: l_error_message VARCHAR2(2000);

Line 1040: p_cc_type IN igc_cc_headers.cc_type%TYPE,

1036: PROCEDURE validate_enc_pf_date (
1037: p_interface_header_id IN NUMBER,
1038: p_org_id IN NUMBER,
1039: p_set_of_books_id IN NUMBER,
1040: p_cc_type IN igc_cc_headers.cc_type%TYPE,
1041: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1042: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
1043: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
1044: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */

Line 1041: p_cc_state IN igc_cc_headers.cc_state%TYPE,

1037: p_interface_header_id IN NUMBER,
1038: p_org_id IN NUMBER,
1039: p_set_of_books_id IN NUMBER,
1040: p_cc_type IN igc_cc_headers.cc_type%TYPE,
1041: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1042: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
1043: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
1044: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */
1045: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,

Line 1042: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,

1038: p_org_id IN NUMBER,
1039: p_set_of_books_id IN NUMBER,
1040: p_cc_type IN igc_cc_headers.cc_type%TYPE,
1041: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1042: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
1043: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
1044: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */
1045: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
1046: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,

Line 1043: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,

1039: p_set_of_books_id IN NUMBER,
1040: p_cc_type IN igc_cc_headers.cc_type%TYPE,
1041: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1042: p_cc_encmbrnc_status IN igc_cc_headers.cc_encmbrnc_status%TYPE,
1043: p_cc_apprvl_status IN igc_cc_headers.cc_apprvl_status%TYPE,
1044: /* Bug No : 6341012. SLA uptake. cc_flags no more exists */
1045: -- p_cc_prov_encmbrnc_flag IN VARCHAR2,
1046: -- p_cc_conf_encmbrnc_flag IN VARCHAR2,
1047: p_sb_prov_encmbrnc_flag IN VARCHAR2,

Line 1056: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,

1052: p_interface_det_pf_id IN VARCHAR2,
1053: p_interface_parent_det_pf_id IN NUMBER,
1054: p_cc_det_pf_date IN DATE,
1055: p_cc_det_pf_encmbrnc_date IN DATE,
1056: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
1057: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
1058: p_x_error_status IN OUT NOCOPY VARCHAR2)
1059: IS
1060: l_error_message VARCHAR2(2000);

Line 1057: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,

1053: p_interface_parent_det_pf_id IN NUMBER,
1054: p_cc_det_pf_date IN DATE,
1055: p_cc_det_pf_encmbrnc_date IN DATE,
1056: p_cc_start_date IN igc_cc_headers.cc_start_date%TYPE,
1057: p_cc_end_date IN igc_cc_headers.cc_start_date%TYPE,
1058: p_x_error_status IN OUT NOCOPY VARCHAR2)
1059: IS
1060: l_error_message VARCHAR2(2000);
1061: l_valid BOOLEAN := TRUE;

Line 1157: p_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,

1153: -- Bug 2871052, Bidisha S Start
1154: -- Populate the PA plsql tables for Commitment bduget
1155: PROCEDURE populate_pa_table
1156: (p_budget_type IN VARCHAR2,
1157: p_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
1158: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,
1159: p_cc_det_pf_line_id IN igc_cc_det_pf.cc_det_pf_line_id%TYPE,
1160: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1161: p_project_id IN igc_cc_acct_lines.project_id%TYPE,

Line 1160: p_cc_state IN igc_cc_headers.cc_state%TYPE,

1156: (p_budget_type IN VARCHAR2,
1157: p_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
1158: p_cc_acct_line_id IN igc_cc_acct_lines.cc_acct_line_id%TYPE,
1159: p_cc_det_pf_line_id IN igc_cc_det_pf.cc_det_pf_line_id%TYPE,
1160: p_cc_state IN igc_cc_headers.cc_state%TYPE,
1161: p_project_id IN igc_cc_acct_lines.project_id%TYPE,
1162: p_task_id IN igc_cc_acct_lines.task_id%TYPE,
1163: p_expenditure_type IN igc_cc_acct_lines.expenditure_type%TYPE,
1164: p_expenditure_item_date IN igc_cc_acct_lines.expenditure_item_date%TYPE,

Line 1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;

1376: l_msg_data VARCHAR2(12000);
1377: l_error_text VARCHAR2(12000);
1378: l_msg_buf VARCHAR2(2000);
1379: l_request_id NUMBER;
1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;
1381: l_start_date gl_periods.start_date%TYPE;
1382: l_end_date gl_periods.end_date%TYPE;
1383: l_curr_year_pf_lines NUMBER;
1384: l_error_message igc_cc_interface_errors.error_message%TYPE;

Line 1409: SELECT * FROM igc_cc_headers_interface

1405: l_lang VARCHAR2(10):='en';
1406: l_layout BOOLEAN;
1407:
1408: CURSOR c_interface_header_records IS
1409: SELECT * FROM igc_cc_headers_interface
1410: WHERE batch_id = P_Batch_Id
1411: ORDER BY cc_type DESC;
1412:
1413: -- Start Date and End Date of current fiscal year for set of books

Line 1615: IGC_CC_HEADERS_PKG.Insert_Row(

1611: -- fix bug 2197872 end(2)
1612:
1613: END IF;
1614:
1615: IGC_CC_HEADERS_PKG.Insert_Row(
1616: 1.0,
1617: FND_API.G_TRUE,
1618: FND_API.G_FALSE,
1619: FND_API.G_VALID_LEVEL_FULL,

Line 2418: DELETE IGC.igc_cc_headers_interface

2414: END IF;
2415: -- bug 3199488, end block
2416:
2417: /*
2418: DELETE IGC.igc_cc_headers_interface
2419: WHERE batch_id = P_Batch_Id;
2420: DELETE IGC.igc_cc_acct_lines_interface
2421: WHERE batch_id = P_Batch_Id;
2422: DELETE IGC.igc_cc_det_pf_interface

Line 2686: FROM igc_cc_headers

2682: END IF;
2683:
2684: -- Check whether the CC Number already exists in the database.
2685: SELECT COUNT(*) INTO l_count
2686: FROM igc_cc_headers
2687: WHERE org_id = P_Org_Id
2688: AND cc_num = P_Cc_Num;
2689:
2690: IF l_count > 0 THEN

Line 2762: FROM igc_cc_headers_interface

2758: ELSE
2759: BEGIN
2760: SELECT interface_header_id, cc_start_date, cc_end_date, currency_code, conversion_type, conversion_rate, conversion_date
2761: INTO l_interface_parent_header_id, l_start_date, l_end_date, l_curr_code, l_conversion_type, l_conversion_rate, l_conversion_date
2762: FROM igc_cc_headers_interface
2763: WHERE interface_header_id = P_Interface_Parent_Header_Id
2764: AND cc_type = 'C';
2765: IF P_Cc_Start_Date < l_start_date THEN
2766: l_error_message := NULL;