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.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_GROUPS

Line 917: invalid_group ap_awt_groups.group_id%TYPE;

913: gl_period_name ap_invoice_distributions.period_name%TYPE;
914: gl_awt_date DATE;
915:
916: -- Invalid Situations Variables
917: invalid_group ap_awt_groups.group_id%TYPE;
918: invalid_tax ap_tax_codes.name%TYPE;
919:
920: -- PL/SQL debugging/logging Objects:
921:

Line 944: TABLE OF ap_awt_groups.group_id%TYPE

940:
941: -- PL/SQL Main Block Tables:
942:
943: TYPE Group_Id_TabTyp IS
944: TABLE OF ap_awt_groups.group_id%TYPE
945: INDEX BY binary_integer;
946: tab_group_id Group_Id_TabTyp;
947:
948: TYPE Amount_By_Group_TabTyp IS

Line 999: FROM ap_awt_groups

995: RETURN VARCHAR2
996: IS
997: CURSOR c_group_name IS
998: SELECT name
999: FROM ap_awt_groups
1000: WHERE (group_id = GroupId);
1001:
1002: group_name ap_awt_groups.name%TYPE;
1003: current_calling_sequence VARCHAR2(2000);

Line 1002: group_name ap_awt_groups.name%TYPE;

998: SELECT name
999: FROM ap_awt_groups
1000: WHERE (group_id = GroupId);
1001:
1002: group_name ap_awt_groups.name%TYPE;
1003: current_calling_sequence VARCHAR2(2000);
1004: debug_info VARCHAR2(100);
1005: BEGIN
1006: current_calling_sequence := 'AP_CALC_WITHHOLDING_PKG.Get_Group_Name<-' ||

Line 1866: ap_awt_groups G

1862: AID.amount,AID.base_amount,AID.line_type_lookup_code
1863: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP
1864: where AID.invoice_id = InvId
1865: AND AID.org_id = AIP.org_id ) D,
1866: ap_awt_groups G
1867: where D.group_id = G.group_id(+)
1868: AND D.line_type_lookup_code <> 'AWT'
1869: GROUP BY D.group_id,
1870: DECODE ( SIGN(WTDate - G.inactive_date),

Line 2781: invalid_group_name ap_awt_groups.name%TYPE;

2777: END;
2778:
2779: WHEN INVALID_RANGE THEN
2780: DECLARE
2781: invalid_group_name ap_awt_groups.name%TYPE;
2782: error_text VARCHAR2(2000);
2783: BEGIN
2784:
2785: invalid_group_name := Get_Group_Name(invalid_group

Line 2801: invalid_group_name ap_awt_groups.name%TYPE;

2797: END;
2798:
2799: WHEN ONE_INVALID_GROUP THEN
2800: DECLARE
2801: invalid_group_name ap_awt_groups.name%TYPE;
2802: error_text VARCHAR2(2000);
2803: BEGIN
2804: invalid_group_name := Get_Group_Name(invalid_group
2805: ,current_calling_sequence);

Line 2814: invalid_group_name ap_awt_groups.name%TYPE;

2810: END;
2811:
2812: WHEN ONE_INVALID_TAX THEN
2813: DECLARE
2814: invalid_group_name ap_awt_groups.name%TYPE;
2815: error_text VARCHAR2(2000);
2816: BEGIN
2817: invalid_group_name := Get_Group_Name(invalid_group
2818: ,current_calling_sequence);

Line 2833: invalid_group_name ap_awt_groups.name%TYPE;

2829: END;
2830:
2831: WHEN ONE_INVALID_TAX_ACCOUNT THEN
2832: DECLARE
2833: invalid_group_name ap_awt_groups.name%TYPE;
2834: error_text VARCHAR2(2000);
2835: BEGIN
2836: invalid_group_name := Get_Group_Name(invalid_group
2837: ,current_calling_sequence);

Line 2852: invalid_group_name ap_awt_groups.name%TYPE;

2848: END;
2849:
2850: WHEN ONE_TAX_MISSING_PERIOD THEN
2851: DECLARE
2852: invalid_group_name ap_awt_groups.name%TYPE;
2853: error_text VARCHAR2(2000);
2854: BEGIN
2855: invalid_group_name := Get_Group_Name(invalid_group
2856: ,current_calling_sequence);

Line 2871: invalid_group_name ap_awt_groups.name%TYPE;

2867: END;
2868:
2869: WHEN NO_VALID_TAX_RATES THEN
2870: DECLARE
2871: invalid_group_name ap_awt_groups.name%TYPE;
2872: error_text VARCHAR2(2000);
2873: BEGIN
2874: invalid_group_name := Get_Group_Name(invalid_group
2875: ,current_calling_sequence);

Line 2890: invalid_group_name ap_awt_groups.name%TYPE;

2886: END;
2887:
2888: WHEN INVALID_RANGE_DATES THEN
2889: DECLARE
2890: invalid_group_name ap_awt_groups.name%TYPE;
2891: error_text VARCHAR2(2000);
2892: BEGIN
2893: invalid_group_name := Get_Group_Name(invalid_group
2894: ,current_calling_sequence);

Line 2909: invalid_group_name ap_awt_groups.name%TYPE;

2905: END;
2906:
2907: WHEN INV_CURR_MUST_BE_BASE THEN
2908: DECLARE
2909: invalid_group_name ap_awt_groups.name%TYPE;
2910: error_text VARCHAR2(2000);
2911: BEGIN
2912: invalid_group_name := Get_Group_Name(invalid_group
2913: ,current_calling_sequence);