APPS.AP_HOLDS_PKG dependencies on AP_HOLD_CODES

Line 161: FROM ap_hold_codes

157: SELECT nvl(user_releaseable_flag,'N'),
158: nvl(initiate_workflow_flag,'N')
159: INTO l_user_releaseable_flag,
160: l_initiate_workflow_flag
161: FROM ap_hold_codes
162: WHERE hold_lookup_code = X_Hold_Lookup_Code;
163:
164: IF (l_user_releaseable_flag = 'Y' AND
165: l_initiate_workflow_flag = 'Y') THEN

Line 624: from ap_hold_codes

620: l_hold_reason ap_holds.hold_reason%TYPE; --bug 1188566
621:
622: cursor hold_cursor is
623: select description
624: from ap_hold_codes
625: where hold_type = nvl(X_hold_type,hold_type)
626: and hold_lookup_code = X_hold_lookup_code;
627:
628: l_api_name varchar2(50);

Line 646: -- need to get a description from AP_HOLD_CODES. We don't want

642: return;
643: end if;
644:
645: -- If a hold reason was passed to the function, then we do not
646: -- need to get a description from AP_HOLD_CODES. We don't want
647: -- to override the user-entered description
648:
649: if (X_hold_reason is null) then
650: debug_info := 'Select from AP_HOLD_CODES';

Line 650: debug_info := 'Select from AP_HOLD_CODES';

646: -- need to get a description from AP_HOLD_CODES. We don't want
647: -- to override the user-entered description
648:
649: if (X_hold_reason is null) then
650: debug_info := 'Select from AP_HOLD_CODES';
651: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
652: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
653: END IF;
654:

Line 743: l_hold_reason ap_hold_codes.description%TYPE;

739: X_calling_sequence IN varchar2 DEFAULT NULL)
740: IS
741: current_calling_sequence VARCHAR2(2000);
742: debug_info VARCHAR2(100);
743: l_hold_reason ap_hold_codes.description%TYPE;
744: l_last_updated_by ap_invoices.last_updated_by%TYPE;
745: l_last_update_login ap_invoices.last_update_login%TYPE;
746:
747: cursor invoice_who_cursor is