DBA Data[Home] [Help]

APPS.OKL_POOLCONC_PVT dependencies on FND_DATE

Line 504: ,p_start_date_from => fnd_date.canonical_to_date(p_start_from_date)

500: ,p_pre_tax_yield_to => TO_NUMBER(p_pre_tax_yield_to)
501: ,p_book_classification => p_book_classification
502: ,p_tax_owner => p_tax_owner
503: ,p_pdt_id => TO_NUMBER(p_pdt_id)
504: ,p_start_date_from => fnd_date.canonical_to_date(p_start_from_date)
505: ,p_start_date_to => fnd_date.canonical_to_date(p_start_to_date)
506: ,p_end_date_from => fnd_date.canonical_to_date(p_end_from_date)
507: ,p_end_date_to => fnd_date.canonical_to_date(p_end_to_date)
508: ,p_asset_id => TO_NUMBER(p_asset_id)

Line 505: ,p_start_date_to => fnd_date.canonical_to_date(p_start_to_date)

501: ,p_book_classification => p_book_classification
502: ,p_tax_owner => p_tax_owner
503: ,p_pdt_id => TO_NUMBER(p_pdt_id)
504: ,p_start_date_from => fnd_date.canonical_to_date(p_start_from_date)
505: ,p_start_date_to => fnd_date.canonical_to_date(p_start_to_date)
506: ,p_end_date_from => fnd_date.canonical_to_date(p_end_from_date)
507: ,p_end_date_to => fnd_date.canonical_to_date(p_end_to_date)
508: ,p_asset_id => TO_NUMBER(p_asset_id)
509: ,p_item_id1 => TO_NUMBER(p_item_id1)

Line 506: ,p_end_date_from => fnd_date.canonical_to_date(p_end_from_date)

502: ,p_tax_owner => p_tax_owner
503: ,p_pdt_id => TO_NUMBER(p_pdt_id)
504: ,p_start_date_from => fnd_date.canonical_to_date(p_start_from_date)
505: ,p_start_date_to => fnd_date.canonical_to_date(p_start_to_date)
506: ,p_end_date_from => fnd_date.canonical_to_date(p_end_from_date)
507: ,p_end_date_to => fnd_date.canonical_to_date(p_end_to_date)
508: ,p_asset_id => TO_NUMBER(p_asset_id)
509: ,p_item_id1 => TO_NUMBER(p_item_id1)
510: ,p_model_number => p_model_number

Line 507: ,p_end_date_to => fnd_date.canonical_to_date(p_end_to_date)

503: ,p_pdt_id => TO_NUMBER(p_pdt_id)
504: ,p_start_date_from => fnd_date.canonical_to_date(p_start_from_date)
505: ,p_start_date_to => fnd_date.canonical_to_date(p_start_to_date)
506: ,p_end_date_from => fnd_date.canonical_to_date(p_end_from_date)
507: ,p_end_date_to => fnd_date.canonical_to_date(p_end_to_date)
508: ,p_asset_id => TO_NUMBER(p_asset_id)
509: ,p_item_id1 => TO_NUMBER(p_item_id1)
510: ,p_model_number => p_model_number
511: ,p_manufacturer_name => p_manufacturer_name

Line 518: ,p_stream_element_from_date => fnd_date.canonical_to_date(p_streams_from_date)

514: ,p_oec_to => TO_NUMBER(p_oec_to)
515: ,p_residual_percentage => TO_NUMBER(p_residual_percentage)
516: ,p_sty_id1 => TO_NUMBER(p_sty_id1)
517: ,p_sty_id2 => TO_NUMBER(p_sty_id2)
518: ,p_stream_element_from_date => fnd_date.canonical_to_date(p_streams_from_date)
519: ,p_stream_element_to_date => fnd_date.canonical_to_date(p_streams_to_date)
520: ,p_stream_element_payment_freq => p_stream_element_payment_freq
521: ,p_stream_type_subclass => p_stream_type_subclass
522: ,p_cust_crd_clf_code => p_cust_crd_clf_code);

Line 519: ,p_stream_element_to_date => fnd_date.canonical_to_date(p_streams_to_date)

515: ,p_residual_percentage => TO_NUMBER(p_residual_percentage)
516: ,p_sty_id1 => TO_NUMBER(p_sty_id1)
517: ,p_sty_id2 => TO_NUMBER(p_sty_id2)
518: ,p_stream_element_from_date => fnd_date.canonical_to_date(p_streams_from_date)
519: ,p_stream_element_to_date => fnd_date.canonical_to_date(p_streams_to_date)
520: ,p_stream_element_payment_freq => p_stream_element_payment_freq
521: ,p_stream_type_subclass => p_stream_type_subclass
522: ,p_cust_crd_clf_code => p_cust_crd_clf_code);
523:

Line 720: ,argument12 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_from_date)

716: ,argument8 => TO_CHAR(p_polsrch_rec.pre_tax_yield_to)
717: ,argument9 => p_polsrch_rec.book_classification
718: ,argument10 => p_polsrch_rec.tax_owner
719: ,argument11 => TO_CHAR(p_polsrch_rec.pdt_id)
720: ,argument12 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_from_date)
721: ,argument13 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_to_date)
722: ,argument14 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_from_date)
723: ,argument15 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_to_date)
724: ,argument16 => TO_CHAR(p_polsrch_rec.asset_id)

Line 721: ,argument13 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_to_date)

717: ,argument9 => p_polsrch_rec.book_classification
718: ,argument10 => p_polsrch_rec.tax_owner
719: ,argument11 => TO_CHAR(p_polsrch_rec.pdt_id)
720: ,argument12 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_from_date)
721: ,argument13 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_to_date)
722: ,argument14 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_from_date)
723: ,argument15 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_to_date)
724: ,argument16 => TO_CHAR(p_polsrch_rec.asset_id)
725: ,argument17 => TO_CHAR(p_polsrch_rec.item_id1)

Line 722: ,argument14 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_from_date)

718: ,argument10 => p_polsrch_rec.tax_owner
719: ,argument11 => TO_CHAR(p_polsrch_rec.pdt_id)
720: ,argument12 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_from_date)
721: ,argument13 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_to_date)
722: ,argument14 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_from_date)
723: ,argument15 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_to_date)
724: ,argument16 => TO_CHAR(p_polsrch_rec.asset_id)
725: ,argument17 => TO_CHAR(p_polsrch_rec.item_id1)
726: ,argument18 => p_polsrch_rec.model_number

Line 723: ,argument15 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_to_date)

719: ,argument11 => TO_CHAR(p_polsrch_rec.pdt_id)
720: ,argument12 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_from_date)
721: ,argument13 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.start_to_date)
722: ,argument14 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_from_date)
723: ,argument15 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.end_to_date)
724: ,argument16 => TO_CHAR(p_polsrch_rec.asset_id)
725: ,argument17 => TO_CHAR(p_polsrch_rec.item_id1)
726: ,argument18 => p_polsrch_rec.model_number
727: ,argument19 => p_polsrch_rec.manufacturer_name

Line 734: ,argument26 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_from_date)

730: ,argument22 => TO_CHAR(p_polsrch_rec.oec_to)
731: ,argument23 => TO_CHAR(p_polsrch_rec.residual_percentage)
732: ,argument24 => TO_CHAR(p_sty_id1)
733: ,argument25 => TO_CHAR(p_sty_id2)
734: ,argument26 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_from_date)
735: ,argument27 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_to_date)
736: ,argument28 => p_polsrch_rec.stream_element_payment_freq
737: ,argument29 => p_stream_type_subclass
738: ,argument30 => p_polsrch_rec.cust_crd_clf_code

Line 735: ,argument27 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_to_date)

731: ,argument23 => TO_CHAR(p_polsrch_rec.residual_percentage)
732: ,argument24 => TO_CHAR(p_sty_id1)
733: ,argument25 => TO_CHAR(p_sty_id2)
734: ,argument26 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_from_date)
735: ,argument27 => FND_DATE.DATE_TO_CANONICAL(p_polsrch_rec.streams_to_date)
736: ,argument28 => p_polsrch_rec.stream_element_payment_freq
737: ,argument29 => p_stream_type_subclass
738: ,argument30 => p_polsrch_rec.cust_crd_clf_code
739: );

Line 2098: ,p_start_from_date => fnd_date.canonical_to_date(p_start_from_date)

2094: ,p_pre_tax_yield_to => TO_NUMBER(p_pre_tax_yield_to)
2095: ,p_book_classification => p_book_classification
2096: ,p_tax_owner => p_tax_owner
2097: ,p_pdt_id => TO_NUMBER(p_pdt_id)
2098: ,p_start_from_date => fnd_date.canonical_to_date(p_start_from_date)
2099: ,p_start_to_date => fnd_date.canonical_to_date(p_start_to_date)
2100: ,p_end_from_date => fnd_date.canonical_to_date(p_end_from_date)
2101: ,p_end_to_date => fnd_date.canonical_to_date(p_end_to_date)
2102: ,p_asset_id => TO_NUMBER(p_asset_id)

Line 2099: ,p_start_to_date => fnd_date.canonical_to_date(p_start_to_date)

2095: ,p_book_classification => p_book_classification
2096: ,p_tax_owner => p_tax_owner
2097: ,p_pdt_id => TO_NUMBER(p_pdt_id)
2098: ,p_start_from_date => fnd_date.canonical_to_date(p_start_from_date)
2099: ,p_start_to_date => fnd_date.canonical_to_date(p_start_to_date)
2100: ,p_end_from_date => fnd_date.canonical_to_date(p_end_from_date)
2101: ,p_end_to_date => fnd_date.canonical_to_date(p_end_to_date)
2102: ,p_asset_id => TO_NUMBER(p_asset_id)
2103: ,p_item_id1 => TO_NUMBER(p_item_id1)

Line 2100: ,p_end_from_date => fnd_date.canonical_to_date(p_end_from_date)

2096: ,p_tax_owner => p_tax_owner
2097: ,p_pdt_id => TO_NUMBER(p_pdt_id)
2098: ,p_start_from_date => fnd_date.canonical_to_date(p_start_from_date)
2099: ,p_start_to_date => fnd_date.canonical_to_date(p_start_to_date)
2100: ,p_end_from_date => fnd_date.canonical_to_date(p_end_from_date)
2101: ,p_end_to_date => fnd_date.canonical_to_date(p_end_to_date)
2102: ,p_asset_id => TO_NUMBER(p_asset_id)
2103: ,p_item_id1 => TO_NUMBER(p_item_id1)
2104: ,p_model_number => p_model_number

Line 2101: ,p_end_to_date => fnd_date.canonical_to_date(p_end_to_date)

2097: ,p_pdt_id => TO_NUMBER(p_pdt_id)
2098: ,p_start_from_date => fnd_date.canonical_to_date(p_start_from_date)
2099: ,p_start_to_date => fnd_date.canonical_to_date(p_start_to_date)
2100: ,p_end_from_date => fnd_date.canonical_to_date(p_end_from_date)
2101: ,p_end_to_date => fnd_date.canonical_to_date(p_end_to_date)
2102: ,p_asset_id => TO_NUMBER(p_asset_id)
2103: ,p_item_id1 => TO_NUMBER(p_item_id1)
2104: ,p_model_number => p_model_number
2105: ,p_manufacturer_name => p_manufacturer_name

Line 2114: ,p_streams_from_date => fnd_date.canonical_to_date(p_streams_from_date)

2110: ,p_sty_id => TO_NUMBER(p_sty_id)
2111: -- mvasudev, 11.5.10
2112: ,p_stream_type_subclass => p_stream_type_subclass
2113: -- end, mvasudev, 11.5.10
2114: ,p_streams_from_date => fnd_date.canonical_to_date(p_streams_from_date)
2115: ,p_streams_to_date => fnd_date.canonical_to_date(p_streams_to_date)
2116: ,p_action_code => p_action_code
2117: ,x_poc_uv_tbl => lx_poc_uv_tbl
2118: ,p_cust_crd_clf_code => p_cust_crd_clf_code);

Line 2115: ,p_streams_to_date => fnd_date.canonical_to_date(p_streams_to_date)

2111: -- mvasudev, 11.5.10
2112: ,p_stream_type_subclass => p_stream_type_subclass
2113: -- end, mvasudev, 11.5.10
2114: ,p_streams_from_date => fnd_date.canonical_to_date(p_streams_from_date)
2115: ,p_streams_to_date => fnd_date.canonical_to_date(p_streams_to_date)
2116: ,p_action_code => p_action_code
2117: ,x_poc_uv_tbl => lx_poc_uv_tbl
2118: ,p_cust_crd_clf_code => p_cust_crd_clf_code);
2119: