[Home] [Help]
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
647: cursor hold_cursor is
648: select nvl(X_hold_reason, description),
649: nvl(user_releaseable_flag,'N'),
650: nvl(initiate_workflow_flag,'N')
651: from ap_hold_codes
652: where hold_type = nvl(X_hold_type,hold_type)
653: and hold_lookup_code = X_hold_lookup_code;
654:
655: l_api_name varchar2(50);
669: return;
670: end if;
671:
672: -- If a hold reason was passed to the function, then we do not
673: -- need to get a description from AP_HOLD_CODES. We don't want
674: -- to override the user-entered description
675:
676: -- Bug 9715670.
677: -- Moved cursor out of if to fetch user releasable flag
677: -- Moved cursor out of if to fetch user releasable flag
678: -- and workflow flag as well. After modification to the
679: -- cursor, if is not required.
680:
681: debug_info := 'Select from AP_HOLD_CODES';
682: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
684: END IF;
685:
695: END IF;
696:
697: -- Bug 9715670. Commented following if.
698: /*if (X_hold_reason is null) then
699: -- debug_info := 'Select from AP_HOLD_CODES';
700: -- IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
701: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
702: -- END IF;
703:
806: X_calling_sequence IN varchar2 DEFAULT NULL)
807: IS
808: current_calling_sequence VARCHAR2(2000);
809: debug_info VARCHAR2(100);
810: l_hold_reason ap_hold_codes.description%TYPE;
811: l_last_updated_by ap_invoices.last_updated_by%TYPE;
812: l_last_update_login ap_invoices.last_update_login%TYPE;
813:
814: cursor invoice_who_cursor is