APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on DUAL

Line 417: debug_info := 'Select from sys.dual';

413: --
414: current_calling_sequence :=
415: 'AP_INVOICE_DISTRIBUTIONS_PKG.All_Encumbered<-'||X_Calling_Sequence;
416:
417: debug_info := 'Select from sys.dual';
418:
419: select 'There are encumbered dists'
420: into dummy
421: from sys.dual

Line 421: from sys.dual

417: debug_info := 'Select from sys.dual';
418:
419: select 'There are encumbered dists'
420: into dummy
421: from sys.dual
422: where not exists (select 'There are other unencumbered dists'
423: from ap_invoice_distributions
424: where invoice_id = X_Invoice_Id
425: and NVL(match_status_flag, 'N') <> 'A'

Line 676: debug_info := 'Select from sys.dual';

672: --
673: current_calling_sequence :=
674: 'AP_INVOICE_DISTRIBUTION_PKG.Substrbyte<-'||X_Calling_Sequence;
675:
676: debug_info := 'Select from sys.dual';
677:
678: select SUBSTRB(X_String, X_Start, X_End)
679: into result_str
680: from sys.dual;

Line 680: from sys.dual;

676: debug_info := 'Select from sys.dual';
677:
678: select SUBSTRB(X_String, X_Start, X_End)
679: into result_str
680: from sys.dual;
681:
682: return(result_str);
683:
684: EXCEPTION

Line 810: FROM DUAL;

806: where invoice_id = X_invoice_id;
807:
808: SELECT JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)
809: INTO l_country_code
810: FROM DUAL;
811: --bug 9169915
812:
813: --Start Bug#10241241
814: select chart_of_accounts_id

Line 824: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

820: --End Bug#10241241
821:
822: FOR i in nvl(X_dist_tab.FIRST, 0) .. nvl(X_dist_tab.LAST, -1) LOOP
823:
824: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
825:
826: INSERT INTO ap_invoice_distributions (
827: batch_id,
828: invoice_id,

Line 4985: FROM DUAL;

4981:
4982: --bug 9169915 bug9737142
4983: SELECT JG_ZZ_SHARED_PKG.GET_COUNTRY(l_invoice_line_rec.org_id, null)
4984: INTO l_country_code
4985: FROM DUAL;
4986:
4987: IF l_country_code IN ('AR','CO') THEN
4988: JL_ZZ_AP_AWT_DEFAULT_PKG.SUPP_WH_DEF (l_invoice_line_rec.invoice_id,
4989: l_invoice_line_rec.line_number,

Line 7622: FROM DUAL;

7618:
7619: --bug 9169915
7620: SELECT JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)
7621: INTO l_country_code
7622: FROM DUAL;
7623: --bug 9169915
7624:
7625: ----------------------------------------------------------------------------
7626: -- Step 11 - Generate distributions

Line 7655: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

7651: -- Bug 13841774. End.
7652:
7653: FOR i in nvl(l_dist_tab.FIRST, 0) .. nvl(l_dist_tab.LAST, -1) LOOP
7654:
7655: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
7656:
7657: INSERT INTO ap_invoice_distributions(
7658: batch_id,
7659: invoice_id,

Line 9278: FROM DUAL WHERE EXISTS

9274: L_AWT_COMPUTED VARCHAR2(2):='N';
9275: BEGIN
9276: BEGIN
9277: SELECT 'Y' INTO L_AWT_COMPUTED
9278: FROM DUAL WHERE EXISTS
9279: (
9280: SELECT INVOICE_DISTRIBUTION_ID
9281: FROM AP_INVOICE_DISTRIBUTIONS
9282: WHERE LINE_TYPE_LOOKUP_CODE='AWT'