APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_GROUPS

Line 1112: invalid_group ap_awt_groups.group_id%TYPE;

1108: max_gl_dist_date DATE; /* Added for bug#6605368 */
1109: max_gl_date_period gl_period_statuses.period_name%TYPE; /* Added for bug#6605368 */
1110:
1111: -- Invalid Situations Variables
1112: invalid_group ap_awt_groups.group_id%TYPE;
1113: invalid_tax ap_tax_codes.name%TYPE;
1114:
1115: -- PL/SQL debugging/logging Objects:
1116:

Line 1139: TABLE OF ap_awt_groups.group_id%TYPE

1135:
1136: -- PL/SQL Main Block Tables:
1137:
1138: TYPE Group_Id_TabTyp IS
1139: TABLE OF ap_awt_groups.group_id%TYPE
1140: INDEX BY binary_integer;
1141: tab_group_id Group_Id_TabTyp;
1142:
1143: TYPE Amount_By_Group_TabTyp IS

Line 1214: FROM ap_awt_groups

1210: RETURN VARCHAR2
1211: IS
1212: CURSOR c_group_name IS
1213: SELECT name
1214: FROM ap_awt_groups
1215: WHERE (group_id = GroupId);
1216:
1217: group_name ap_awt_groups.name%TYPE;
1218: current_calling_sequence VARCHAR2(2000);

Line 1217: group_name ap_awt_groups.name%TYPE;

1213: SELECT name
1214: FROM ap_awt_groups
1215: WHERE (group_id = GroupId);
1216:
1217: group_name ap_awt_groups.name%TYPE;
1218: current_calling_sequence VARCHAR2(2000);
1219: debug_info VARCHAR2(100);
1220: BEGIN
1221: current_calling_sequence := 'AP_CALC_WITHHOLDING_PKG.Get_Group_Name<-' ||

Line 2178: ap_awt_groups G

2174: AID.amount,AID.base_amount,AID.line_type_lookup_code, AID.accounting_date /* Added AID.accounting_date for bug#6605368 */
2175: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP
2176: where AID.invoice_id = InvId
2177: AND AID.org_id = AIP.org_id ) D,
2178: ap_awt_groups G
2179: where D.group_id = G.group_id(+)
2180: AND D.line_type_lookup_code <> 'AWT'
2181: GROUP BY D.group_id,
2182: DECODE ( SIGN(WTDate - G.inactive_date),

Line 3192: invalid_group_name ap_awt_groups.name%TYPE;

3188: END;
3189:
3190: WHEN INVALID_RANGE THEN
3191: DECLARE
3192: invalid_group_name ap_awt_groups.name%TYPE;
3193: error_text VARCHAR2(2000);
3194: BEGIN
3195:
3196: invalid_group_name := Get_Group_Name(invalid_group

Line 3212: invalid_group_name ap_awt_groups.name%TYPE;

3208: END;
3209:
3210: WHEN ONE_INVALID_GROUP THEN
3211: DECLARE
3212: invalid_group_name ap_awt_groups.name%TYPE;
3213: error_text VARCHAR2(2000);
3214: BEGIN
3215: invalid_group_name := Get_Group_Name(invalid_group
3216: ,current_calling_sequence);

Line 3225: invalid_group_name ap_awt_groups.name%TYPE;

3221: END;
3222:
3223: WHEN ONE_INVALID_TAX THEN
3224: DECLARE
3225: invalid_group_name ap_awt_groups.name%TYPE;
3226: error_text VARCHAR2(2000);
3227: BEGIN
3228: invalid_group_name := Get_Group_Name(invalid_group
3229: ,current_calling_sequence);

Line 3244: invalid_group_name ap_awt_groups.name%TYPE;

3240: END;
3241:
3242: WHEN ONE_INVALID_TAX_ACCOUNT THEN
3243: DECLARE
3244: invalid_group_name ap_awt_groups.name%TYPE;
3245: error_text VARCHAR2(2000);
3246: BEGIN
3247: invalid_group_name := Get_Group_Name(invalid_group
3248: ,current_calling_sequence);

Line 3263: invalid_group_name ap_awt_groups.name%TYPE;

3259: END;
3260:
3261: WHEN ONE_TAX_MISSING_PERIOD THEN
3262: DECLARE
3263: invalid_group_name ap_awt_groups.name%TYPE;
3264: error_text VARCHAR2(2000);
3265: BEGIN
3266: invalid_group_name := Get_Group_Name(invalid_group
3267: ,current_calling_sequence);

Line 3282: invalid_group_name ap_awt_groups.name%TYPE;

3278: END;
3279:
3280: WHEN NO_VALID_TAX_RATES THEN
3281: DECLARE
3282: invalid_group_name ap_awt_groups.name%TYPE;
3283: error_text VARCHAR2(2000);
3284: BEGIN
3285: invalid_group_name := Get_Group_Name(invalid_group
3286: ,current_calling_sequence);

Line 3301: invalid_group_name ap_awt_groups.name%TYPE;

3297: END;
3298:
3299: WHEN INVALID_RANGE_DATES THEN
3300: DECLARE
3301: invalid_group_name ap_awt_groups.name%TYPE;
3302: error_text VARCHAR2(2000);
3303: BEGIN
3304: invalid_group_name := Get_Group_Name(invalid_group
3305: ,current_calling_sequence);

Line 3320: invalid_group_name ap_awt_groups.name%TYPE;

3316: END;
3317:
3318: WHEN INV_CURR_MUST_BE_BASE THEN
3319: DECLARE
3320: invalid_group_name ap_awt_groups.name%TYPE;
3321: error_text VARCHAR2(2000);
3322: BEGIN
3323: invalid_group_name := Get_Group_Name(invalid_group
3324: ,current_calling_sequence);