APPS.ICX_REQ_SUBMIT dependencies on FND_API

Line 575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,

571: -------------------------------------------------------------
572: procedure finalSubmit(user_action varchar2,
573: icx_cart_id varchar2,
574: emergency IN varchar2 default NULL,
575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,

Line 576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,

572: procedure finalSubmit(user_action varchar2,
573: icx_cart_id varchar2,
574: emergency IN varchar2 default NULL,
575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,

Line 577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,

573: icx_cart_id varchar2,
574: emergency IN varchar2 default NULL,
575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,

Line 578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,

574: emergency IN varchar2 default NULL,
575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,

Line 579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,

575: icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,

Line 580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,

576: icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,

Line 581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,

577: icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,

Line 582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,

578: icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,

Line 583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,

579: icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,

Line 584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,

580: icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,

Line 585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,

581: icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,

Line 586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,

582: icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,

Line 587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,

583: icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,

Line 588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,

584: icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,

Line 589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,

585: icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,

Line 590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,

586: icx_header_description varchar2 default FND_API.G_MISS_CHAR,
587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,

Line 591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,

587: icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,

Line 592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,

588: icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,

Line 593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,

589: icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,

Line 594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,

590: icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,

Line 595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,

591: icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,

Line 596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,

592: icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,

Line 597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,

593: icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,

Line 598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,

594: icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,

Line 599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,

595: icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,

Line 600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,

596: icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,

Line 601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,

597: icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,

Line 602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,

598: icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,

Line 603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,

599: icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,

Line 604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,

600: icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,

Line 605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,

601: icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,

Line 606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,

602: icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,

Line 607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,

603: icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,

Line 608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,

604: icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,

Line 609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,

605: icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,

Line 610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,

606: icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,

Line 611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,

607: icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,

Line 612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,

608: icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,

Line 613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,

609: icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,

Line 614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,

610: icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,

Line 615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,

611: icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,

Line 616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,

612: icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,

Line 617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,

613: icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,

Line 618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,

614: icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,

Line 619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,

615: icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,

Line 620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,

616: icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,

Line 621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,

617: icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,

Line 622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,

618: icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,

Line 623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,

619: icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,

Line 624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,

620: icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,

Line 625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,

621: icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,

Line 626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,

622: icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,

Line 627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,

623: icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,

Line 628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,

624: icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,

Line 629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,

625: icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,

Line 630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,

626: icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,

Line 631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,

627: icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,
635: icx_cart_line_ida IN defaultParamType default empty_table,

Line 632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,

628: icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,
635: icx_cart_line_ida IN defaultParamType default empty_table,
636: icx_category_ida IN defaultParamType default empty_table,

Line 633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,

629: icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,
635: icx_cart_line_ida IN defaultParamType default empty_table,
636: icx_category_ida IN defaultParamType default empty_table,
637: icx_category_namea IN defaultParamType default empty_table,

Line 634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,

630: icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
631: icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
632: icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
633: icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
634: icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,
635: icx_cart_line_ida IN defaultParamType default empty_table,
636: icx_category_ida IN defaultParamType default empty_table,
637: icx_category_namea IN defaultParamType default empty_table,
638: icx_item_ida IN defaultParamType default empty_table,

Line 1072: if (icx_need_by_date <> FND_API.G_MISS_CHAR) then

1068: /***********************************************************************/
1069: /***** DO THE HEADER RECORD ********/
1070: /***********************************************************************/
1071: -- check if date is valid
1072: if (icx_need_by_date <> FND_API.G_MISS_CHAR) then
1073: begin
1074: v_need_date := to_date(icx_need_by_date, v_date_format);
1075: if v_need_date <= (sysdate - 1) then
1076: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

Line 1129: set APPROVER_ID = decode(icx_approver_id, FND_API.G_MISS_CHAR, APPROVER_ID,

1125: end if;
1126: end if;
1127:
1128: update ICX_SHOPPING_CARTS
1129: set APPROVER_ID = decode(icx_approver_id, FND_API.G_MISS_CHAR, APPROVER_ID,
1130: icx_approver_id),
1131: APPROVER_NAME = decode(icx_approver_name,
1132: FND_API.G_MISS_CHAR, APPROVER_NAME,
1133: icx_approver_name),

Line 1132: FND_API.G_MISS_CHAR, APPROVER_NAME,

1128: update ICX_SHOPPING_CARTS
1129: set APPROVER_ID = decode(icx_approver_id, FND_API.G_MISS_CHAR, APPROVER_ID,
1130: icx_approver_id),
1131: APPROVER_NAME = decode(icx_approver_name,
1132: FND_API.G_MISS_CHAR, APPROVER_NAME,
1133: icx_approver_name),
1134: DELIVER_TO_LOCATION_ID =
1135: decode(icx_deliver_to_location_id,
1136: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION_ID,

Line 1136: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION_ID,

1132: FND_API.G_MISS_CHAR, APPROVER_NAME,
1133: icx_approver_name),
1134: DELIVER_TO_LOCATION_ID =
1135: decode(icx_deliver_to_location_id,
1136: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION_ID,
1137: icx_deliver_to_location_id),
1138: DELIVER_TO_LOCATION = decode(icx_deliver_to_location,
1139: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION,
1140: icx_deliver_to_location),

Line 1139: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION,

1135: decode(icx_deliver_to_location_id,
1136: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION_ID,
1137: icx_deliver_to_location_id),
1138: DELIVER_TO_LOCATION = decode(icx_deliver_to_location,
1139: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION,
1140: icx_deliver_to_location),
1141: DELIVER_TO_REQUESTOR_ID =
1142: decode(icx_deliver_to_requestor_id,
1143: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR_ID,

Line 1143: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR_ID,

1139: FND_API.G_MISS_CHAR, DELIVER_TO_LOCATION,
1140: icx_deliver_to_location),
1141: DELIVER_TO_REQUESTOR_ID =
1142: decode(icx_deliver_to_requestor_id,
1143: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR_ID,
1144: icx_deliver_to_requestor_id),
1145: DELIVER_TO_REQUESTOR =
1146: decode(icx_deliver_to_requestor,
1147: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR,

Line 1147: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR,

1143: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR_ID,
1144: icx_deliver_to_requestor_id),
1145: DELIVER_TO_REQUESTOR =
1146: decode(icx_deliver_to_requestor,
1147: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR,
1148: icx_deliver_to_requestor),
1149: DESTINATION_ORGANIZATION_ID =
1150: decode(icx_dest_org_id, FND_API.G_MISS_CHAR, DESTINATION_ORGANIZATION_ID,
1151: icx_dest_org_id),

Line 1150: decode(icx_dest_org_id, FND_API.G_MISS_CHAR, DESTINATION_ORGANIZATION_ID,

1146: decode(icx_deliver_to_requestor,
1147: FND_API.G_MISS_CHAR, DELIVER_TO_REQUESTOR,
1148: icx_deliver_to_requestor),
1149: DESTINATION_ORGANIZATION_ID =
1150: decode(icx_dest_org_id, FND_API.G_MISS_CHAR, DESTINATION_ORGANIZATION_ID,
1151: icx_dest_org_id),
1152: NEED_BY_DATE = decode(icx_need_by_date, FND_API.G_MISS_CHAR, NEED_BY_DATE,
1153: v_need_date),
1154: NOTE_TO_APPROVER = decode(icx_note_to_approver,

Line 1152: NEED_BY_DATE = decode(icx_need_by_date, FND_API.G_MISS_CHAR, NEED_BY_DATE,

1148: icx_deliver_to_requestor),
1149: DESTINATION_ORGANIZATION_ID =
1150: decode(icx_dest_org_id, FND_API.G_MISS_CHAR, DESTINATION_ORGANIZATION_ID,
1151: icx_dest_org_id),
1152: NEED_BY_DATE = decode(icx_need_by_date, FND_API.G_MISS_CHAR, NEED_BY_DATE,
1153: v_need_date),
1154: NOTE_TO_APPROVER = decode(icx_note_to_approver,
1155: FND_API.G_MISS_CHAR, NOTE_TO_APPROVER, icx_note_to_approver),
1156: NOTE_TO_BUYER = decode(icx_note_to_buyer, FND_API.G_MISS_CHAR, NOTE_TO_BUYER,

Line 1155: FND_API.G_MISS_CHAR, NOTE_TO_APPROVER, icx_note_to_approver),

1151: icx_dest_org_id),
1152: NEED_BY_DATE = decode(icx_need_by_date, FND_API.G_MISS_CHAR, NEED_BY_DATE,
1153: v_need_date),
1154: NOTE_TO_APPROVER = decode(icx_note_to_approver,
1155: FND_API.G_MISS_CHAR, NOTE_TO_APPROVER, icx_note_to_approver),
1156: NOTE_TO_BUYER = decode(icx_note_to_buyer, FND_API.G_MISS_CHAR, NOTE_TO_BUYER,
1157: icx_note_to_buyer),
1158: HEADER_DESCRIPTION = decode(icx_header_description,
1159: FND_API.G_MISS_CHAR, HEADER_DESCRIPTION,

Line 1156: NOTE_TO_BUYER = decode(icx_note_to_buyer, FND_API.G_MISS_CHAR, NOTE_TO_BUYER,

1152: NEED_BY_DATE = decode(icx_need_by_date, FND_API.G_MISS_CHAR, NEED_BY_DATE,
1153: v_need_date),
1154: NOTE_TO_APPROVER = decode(icx_note_to_approver,
1155: FND_API.G_MISS_CHAR, NOTE_TO_APPROVER, icx_note_to_approver),
1156: NOTE_TO_BUYER = decode(icx_note_to_buyer, FND_API.G_MISS_CHAR, NOTE_TO_BUYER,
1157: icx_note_to_buyer),
1158: HEADER_DESCRIPTION = decode(icx_header_description,
1159: FND_API.G_MISS_CHAR, HEADER_DESCRIPTION,
1160: icx_header_description),

Line 1159: FND_API.G_MISS_CHAR, HEADER_DESCRIPTION,

1155: FND_API.G_MISS_CHAR, NOTE_TO_APPROVER, icx_note_to_approver),
1156: NOTE_TO_BUYER = decode(icx_note_to_buyer, FND_API.G_MISS_CHAR, NOTE_TO_BUYER,
1157: icx_note_to_buyer),
1158: HEADER_DESCRIPTION = decode(icx_header_description,
1159: FND_API.G_MISS_CHAR, HEADER_DESCRIPTION,
1160: icx_header_description),
1161: HEADER_ATTRIBUTE1 = decode(icx_header_attribute1,
1162: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE1,
1163: icx_header_attribute1),

Line 1162: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE1,

1158: HEADER_DESCRIPTION = decode(icx_header_description,
1159: FND_API.G_MISS_CHAR, HEADER_DESCRIPTION,
1160: icx_header_description),
1161: HEADER_ATTRIBUTE1 = decode(icx_header_attribute1,
1162: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE1,
1163: icx_header_attribute1),
1164: HEADER_ATTRIBUTE2 = decode(icx_header_attribute2,
1165: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE2,
1166: icx_header_attribute2),

Line 1165: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE2,

1161: HEADER_ATTRIBUTE1 = decode(icx_header_attribute1,
1162: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE1,
1163: icx_header_attribute1),
1164: HEADER_ATTRIBUTE2 = decode(icx_header_attribute2,
1165: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE2,
1166: icx_header_attribute2),
1167: HEADER_ATTRIBUTE3 = decode(icx_header_attribute3,
1168: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE3,
1169: icx_header_attribute3),

Line 1168: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE3,

1164: HEADER_ATTRIBUTE2 = decode(icx_header_attribute2,
1165: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE2,
1166: icx_header_attribute2),
1167: HEADER_ATTRIBUTE3 = decode(icx_header_attribute3,
1168: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE3,
1169: icx_header_attribute3),
1170: HEADER_ATTRIBUTE4 = decode(icx_header_attribute4,
1171: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE4,
1172: icx_header_attribute4),

Line 1171: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE4,

1167: HEADER_ATTRIBUTE3 = decode(icx_header_attribute3,
1168: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE3,
1169: icx_header_attribute3),
1170: HEADER_ATTRIBUTE4 = decode(icx_header_attribute4,
1171: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE4,
1172: icx_header_attribute4),
1173: HEADER_ATTRIBUTE5 = decode(icx_header_attribute5,
1174: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE5,
1175: icx_header_attribute5),

Line 1174: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE5,

1170: HEADER_ATTRIBUTE4 = decode(icx_header_attribute4,
1171: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE4,
1172: icx_header_attribute4),
1173: HEADER_ATTRIBUTE5 = decode(icx_header_attribute5,
1174: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE5,
1175: icx_header_attribute5),
1176: HEADER_ATTRIBUTE6 = decode(icx_header_attribute6,
1177: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE6,
1178: icx_header_attribute6),

Line 1177: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE6,

1173: HEADER_ATTRIBUTE5 = decode(icx_header_attribute5,
1174: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE5,
1175: icx_header_attribute5),
1176: HEADER_ATTRIBUTE6 = decode(icx_header_attribute6,
1177: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE6,
1178: icx_header_attribute6),
1179: HEADER_ATTRIBUTE7 = decode(icx_header_attribute7,
1180: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE7,
1181: icx_header_attribute7),

Line 1180: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE7,

1176: HEADER_ATTRIBUTE6 = decode(icx_header_attribute6,
1177: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE6,
1178: icx_header_attribute6),
1179: HEADER_ATTRIBUTE7 = decode(icx_header_attribute7,
1180: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE7,
1181: icx_header_attribute7),
1182: HEADER_ATTRIBUTE8 = decode(icx_header_attribute8,
1183: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE8,
1184: icx_header_attribute8),

Line 1183: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE8,

1179: HEADER_ATTRIBUTE7 = decode(icx_header_attribute7,
1180: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE7,
1181: icx_header_attribute7),
1182: HEADER_ATTRIBUTE8 = decode(icx_header_attribute8,
1183: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE8,
1184: icx_header_attribute8),
1185: HEADER_ATTRIBUTE9 = decode(icx_header_attribute9,
1186: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE9,
1187: icx_header_attribute9),

Line 1186: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE9,

1182: HEADER_ATTRIBUTE8 = decode(icx_header_attribute8,
1183: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE8,
1184: icx_header_attribute8),
1185: HEADER_ATTRIBUTE9 = decode(icx_header_attribute9,
1186: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE9,
1187: icx_header_attribute9),
1188: HEADER_ATTRIBUTE10 = decode(icx_header_attribute10,
1189: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE10,
1190: icx_header_attribute10),

Line 1189: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE10,

1185: HEADER_ATTRIBUTE9 = decode(icx_header_attribute9,
1186: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE9,
1187: icx_header_attribute9),
1188: HEADER_ATTRIBUTE10 = decode(icx_header_attribute10,
1189: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE10,
1190: icx_header_attribute10),
1191: HEADER_ATTRIBUTE11 = decode(icx_header_attribute11,
1192: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE11,
1193: icx_header_attribute11),

Line 1192: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE11,

1188: HEADER_ATTRIBUTE10 = decode(icx_header_attribute10,
1189: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE10,
1190: icx_header_attribute10),
1191: HEADER_ATTRIBUTE11 = decode(icx_header_attribute11,
1192: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE11,
1193: icx_header_attribute11),
1194: HEADER_ATTRIBUTE12 = decode(icx_header_attribute12,
1195: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE12,
1196: icx_header_attribute12),

Line 1195: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE12,

1191: HEADER_ATTRIBUTE11 = decode(icx_header_attribute11,
1192: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE11,
1193: icx_header_attribute11),
1194: HEADER_ATTRIBUTE12 = decode(icx_header_attribute12,
1195: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE12,
1196: icx_header_attribute12),
1197: HEADER_ATTRIBUTE13 = decode(icx_header_attribute13,
1198: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE13,
1199: icx_header_attribute13),

Line 1198: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE13,

1194: HEADER_ATTRIBUTE12 = decode(icx_header_attribute12,
1195: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE12,
1196: icx_header_attribute12),
1197: HEADER_ATTRIBUTE13 = decode(icx_header_attribute13,
1198: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE13,
1199: icx_header_attribute13),
1200: HEADER_ATTRIBUTE14 = decode(icx_header_attribute14,
1201: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE14,
1202: icx_header_attribute14),

Line 1201: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE14,

1197: HEADER_ATTRIBUTE13 = decode(icx_header_attribute13,
1198: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE13,
1199: icx_header_attribute13),
1200: HEADER_ATTRIBUTE14 = decode(icx_header_attribute14,
1201: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE14,
1202: icx_header_attribute14),
1203: HEADER_ATTRIBUTE15 = decode(icx_header_attribute15,
1204: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE15,
1205: icx_header_attribute15),

Line 1204: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE15,

1200: HEADER_ATTRIBUTE14 = decode(icx_header_attribute14,
1201: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE14,
1202: icx_header_attribute14),
1203: HEADER_ATTRIBUTE15 = decode(icx_header_attribute15,
1204: FND_API.G_MISS_CHAR, HEADER_ATTRIBUTE15,
1205: icx_header_attribute15),
1206: RESERVED_PO_NUM = l_po_number,
1207: LAST_UPDATE_DATE = sysdate
1208: where CART_ID = v_cart_id

Line 1215: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT1,

1211:
1212: update icx_cart_distributions
1213: SET LAST_UPDATE_DATE = sysdate,
1214: CHARGE_ACCOUNT_SEGMENT1 = decode(icx_charge_acct_seg1,
1215: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT1,
1216: icx_charge_acct_seg1),
1217: CHARGE_ACCOUNT_SEGMENT2 = decode(icx_charge_acct_seg2,
1218: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT2,
1219: icx_charge_acct_seg2),

Line 1218: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT2,

1214: CHARGE_ACCOUNT_SEGMENT1 = decode(icx_charge_acct_seg1,
1215: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT1,
1216: icx_charge_acct_seg1),
1217: CHARGE_ACCOUNT_SEGMENT2 = decode(icx_charge_acct_seg2,
1218: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT2,
1219: icx_charge_acct_seg2),
1220: CHARGE_ACCOUNT_SEGMENT3 = decode(icx_charge_acct_seg3,
1221: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT3,
1222: icx_charge_acct_seg3),

Line 1221: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT3,

1217: CHARGE_ACCOUNT_SEGMENT2 = decode(icx_charge_acct_seg2,
1218: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT2,
1219: icx_charge_acct_seg2),
1220: CHARGE_ACCOUNT_SEGMENT3 = decode(icx_charge_acct_seg3,
1221: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT3,
1222: icx_charge_acct_seg3),
1223: CHARGE_ACCOUNT_SEGMENT4 = decode(icx_charge_acct_seg4,
1224: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT4,
1225: icx_charge_acct_seg4),

Line 1224: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT4,

1220: CHARGE_ACCOUNT_SEGMENT3 = decode(icx_charge_acct_seg3,
1221: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT3,
1222: icx_charge_acct_seg3),
1223: CHARGE_ACCOUNT_SEGMENT4 = decode(icx_charge_acct_seg4,
1224: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT4,
1225: icx_charge_acct_seg4),
1226: CHARGE_ACCOUNT_SEGMENT5 = decode(icx_charge_acct_seg5,
1227: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT5,
1228: icx_charge_acct_seg5),

Line 1227: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT5,

1223: CHARGE_ACCOUNT_SEGMENT4 = decode(icx_charge_acct_seg4,
1224: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT4,
1225: icx_charge_acct_seg4),
1226: CHARGE_ACCOUNT_SEGMENT5 = decode(icx_charge_acct_seg5,
1227: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT5,
1228: icx_charge_acct_seg5),
1229: CHARGE_ACCOUNT_SEGMENT6 = decode(icx_charge_acct_seg6,
1230: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT6,
1231: icx_charge_acct_seg6),

Line 1230: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT6,

1226: CHARGE_ACCOUNT_SEGMENT5 = decode(icx_charge_acct_seg5,
1227: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT5,
1228: icx_charge_acct_seg5),
1229: CHARGE_ACCOUNT_SEGMENT6 = decode(icx_charge_acct_seg6,
1230: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT6,
1231: icx_charge_acct_seg6),
1232: CHARGE_ACCOUNT_SEGMENT7 = decode(icx_charge_acct_seg7,
1233: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT7,
1234: icx_charge_acct_seg7),

Line 1233: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT7,

1229: CHARGE_ACCOUNT_SEGMENT6 = decode(icx_charge_acct_seg6,
1230: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT6,
1231: icx_charge_acct_seg6),
1232: CHARGE_ACCOUNT_SEGMENT7 = decode(icx_charge_acct_seg7,
1233: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT7,
1234: icx_charge_acct_seg7),
1235: CHARGE_ACCOUNT_SEGMENT8 = decode(icx_charge_acct_seg8,
1236: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT8,
1237: icx_charge_acct_seg8),

Line 1236: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT8,

1232: CHARGE_ACCOUNT_SEGMENT7 = decode(icx_charge_acct_seg7,
1233: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT7,
1234: icx_charge_acct_seg7),
1235: CHARGE_ACCOUNT_SEGMENT8 = decode(icx_charge_acct_seg8,
1236: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT8,
1237: icx_charge_acct_seg8),
1238: CHARGE_ACCOUNT_SEGMENT9 = decode(icx_charge_acct_seg9,
1239: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT9,
1240: icx_charge_acct_seg9),

Line 1239: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT9,

1235: CHARGE_ACCOUNT_SEGMENT8 = decode(icx_charge_acct_seg8,
1236: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT8,
1237: icx_charge_acct_seg8),
1238: CHARGE_ACCOUNT_SEGMENT9 = decode(icx_charge_acct_seg9,
1239: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT9,
1240: icx_charge_acct_seg9),
1241: CHARGE_ACCOUNT_SEGMENT10 = decode(icx_charge_acct_seg10,
1242: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT10,
1243: icx_charge_acct_seg10),

Line 1242: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT10,

1238: CHARGE_ACCOUNT_SEGMENT9 = decode(icx_charge_acct_seg9,
1239: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT9,
1240: icx_charge_acct_seg9),
1241: CHARGE_ACCOUNT_SEGMENT10 = decode(icx_charge_acct_seg10,
1242: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT10,
1243: icx_charge_acct_seg10),
1244: CHARGE_ACCOUNT_SEGMENT11 = decode(icx_charge_acct_seg11,
1245: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT11,
1246: icx_charge_acct_seg11),

Line 1245: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT11,

1241: CHARGE_ACCOUNT_SEGMENT10 = decode(icx_charge_acct_seg10,
1242: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT10,
1243: icx_charge_acct_seg10),
1244: CHARGE_ACCOUNT_SEGMENT11 = decode(icx_charge_acct_seg11,
1245: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT11,
1246: icx_charge_acct_seg11),
1247: CHARGE_ACCOUNT_SEGMENT12 = decode(icx_charge_acct_seg12,
1248: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT12,
1249: icx_charge_acct_seg12),

Line 1248: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT12,

1244: CHARGE_ACCOUNT_SEGMENT11 = decode(icx_charge_acct_seg11,
1245: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT11,
1246: icx_charge_acct_seg11),
1247: CHARGE_ACCOUNT_SEGMENT12 = decode(icx_charge_acct_seg12,
1248: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT12,
1249: icx_charge_acct_seg12),
1250: CHARGE_ACCOUNT_SEGMENT13 = decode(icx_charge_acct_seg13,
1251: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT13,
1252: icx_charge_acct_seg13),

Line 1251: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT13,

1247: CHARGE_ACCOUNT_SEGMENT12 = decode(icx_charge_acct_seg12,
1248: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT12,
1249: icx_charge_acct_seg12),
1250: CHARGE_ACCOUNT_SEGMENT13 = decode(icx_charge_acct_seg13,
1251: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT13,
1252: icx_charge_acct_seg13),
1253: CHARGE_ACCOUNT_SEGMENT14 = decode(icx_charge_acct_seg14,
1254: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT14,
1255: icx_charge_acct_seg14),

Line 1254: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT14,

1250: CHARGE_ACCOUNT_SEGMENT13 = decode(icx_charge_acct_seg13,
1251: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT13,
1252: icx_charge_acct_seg13),
1253: CHARGE_ACCOUNT_SEGMENT14 = decode(icx_charge_acct_seg14,
1254: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT14,
1255: icx_charge_acct_seg14),
1256: CHARGE_ACCOUNT_SEGMENT15 = decode(icx_charge_acct_seg15,
1257: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT15,
1258: icx_charge_acct_seg15),

Line 1257: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT15,

1253: CHARGE_ACCOUNT_SEGMENT14 = decode(icx_charge_acct_seg14,
1254: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT14,
1255: icx_charge_acct_seg14),
1256: CHARGE_ACCOUNT_SEGMENT15 = decode(icx_charge_acct_seg15,
1257: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT15,
1258: icx_charge_acct_seg15),
1259: CHARGE_ACCOUNT_SEGMENT16 = decode(icx_charge_acct_seg16,
1260: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT16,
1261: icx_charge_acct_seg16),

Line 1260: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT16,

1256: CHARGE_ACCOUNT_SEGMENT15 = decode(icx_charge_acct_seg15,
1257: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT15,
1258: icx_charge_acct_seg15),
1259: CHARGE_ACCOUNT_SEGMENT16 = decode(icx_charge_acct_seg16,
1260: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT16,
1261: icx_charge_acct_seg16),
1262: CHARGE_ACCOUNT_SEGMENT17 = decode(icx_charge_acct_seg17,
1263: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT17,
1264: icx_charge_acct_seg17),

Line 1263: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT17,

1259: CHARGE_ACCOUNT_SEGMENT16 = decode(icx_charge_acct_seg16,
1260: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT16,
1261: icx_charge_acct_seg16),
1262: CHARGE_ACCOUNT_SEGMENT17 = decode(icx_charge_acct_seg17,
1263: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT17,
1264: icx_charge_acct_seg17),
1265: CHARGE_ACCOUNT_SEGMENT18 = decode(icx_charge_acct_seg18,
1266: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT18,
1267: icx_charge_acct_seg18),

Line 1266: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT18,

1262: CHARGE_ACCOUNT_SEGMENT17 = decode(icx_charge_acct_seg17,
1263: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT17,
1264: icx_charge_acct_seg17),
1265: CHARGE_ACCOUNT_SEGMENT18 = decode(icx_charge_acct_seg18,
1266: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT18,
1267: icx_charge_acct_seg18),
1268: CHARGE_ACCOUNT_SEGMENT19 = decode(icx_charge_acct_seg19,
1269: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT19,
1270: icx_charge_acct_seg19),

Line 1269: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT19,

1265: CHARGE_ACCOUNT_SEGMENT18 = decode(icx_charge_acct_seg18,
1266: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT18,
1267: icx_charge_acct_seg18),
1268: CHARGE_ACCOUNT_SEGMENT19 = decode(icx_charge_acct_seg19,
1269: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT19,
1270: icx_charge_acct_seg19),
1271: CHARGE_ACCOUNT_SEGMENT20 = decode(icx_charge_acct_seg20,
1272: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT20,
1273: icx_charge_acct_seg20),

Line 1272: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT20,

1268: CHARGE_ACCOUNT_SEGMENT19 = decode(icx_charge_acct_seg19,
1269: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT19,
1270: icx_charge_acct_seg19),
1271: CHARGE_ACCOUNT_SEGMENT20 = decode(icx_charge_acct_seg20,
1272: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT20,
1273: icx_charge_acct_seg20),
1274: CHARGE_ACCOUNT_SEGMENT21 = decode(icx_charge_acct_seg21,
1275: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT21,
1276: icx_charge_acct_seg21),

Line 1275: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT21,

1271: CHARGE_ACCOUNT_SEGMENT20 = decode(icx_charge_acct_seg20,
1272: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT20,
1273: icx_charge_acct_seg20),
1274: CHARGE_ACCOUNT_SEGMENT21 = decode(icx_charge_acct_seg21,
1275: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT21,
1276: icx_charge_acct_seg21),
1277: CHARGE_ACCOUNT_SEGMENT22 = decode(icx_charge_acct_seg22,
1278: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT22,
1279: icx_charge_acct_seg22),

Line 1278: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT22,

1274: CHARGE_ACCOUNT_SEGMENT21 = decode(icx_charge_acct_seg21,
1275: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT21,
1276: icx_charge_acct_seg21),
1277: CHARGE_ACCOUNT_SEGMENT22 = decode(icx_charge_acct_seg22,
1278: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT22,
1279: icx_charge_acct_seg22),
1280: CHARGE_ACCOUNT_SEGMENT23 = decode(icx_charge_acct_seg23,
1281: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT23,
1282: icx_charge_acct_seg23),

Line 1281: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT23,

1277: CHARGE_ACCOUNT_SEGMENT22 = decode(icx_charge_acct_seg22,
1278: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT22,
1279: icx_charge_acct_seg22),
1280: CHARGE_ACCOUNT_SEGMENT23 = decode(icx_charge_acct_seg23,
1281: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT23,
1282: icx_charge_acct_seg23),
1283: CHARGE_ACCOUNT_SEGMENT24 = decode(icx_charge_acct_seg24,
1284: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT24,
1285: icx_charge_acct_seg24),

Line 1284: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT24,

1280: CHARGE_ACCOUNT_SEGMENT23 = decode(icx_charge_acct_seg23,
1281: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT23,
1282: icx_charge_acct_seg23),
1283: CHARGE_ACCOUNT_SEGMENT24 = decode(icx_charge_acct_seg24,
1284: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT24,
1285: icx_charge_acct_seg24),
1286: CHARGE_ACCOUNT_SEGMENT25 = decode(icx_charge_acct_seg25,
1287: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT25,
1288: icx_charge_acct_seg25),

Line 1287: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT25,

1283: CHARGE_ACCOUNT_SEGMENT24 = decode(icx_charge_acct_seg24,
1284: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT24,
1285: icx_charge_acct_seg24),
1286: CHARGE_ACCOUNT_SEGMENT25 = decode(icx_charge_acct_seg25,
1287: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT25,
1288: icx_charge_acct_seg25),
1289: CHARGE_ACCOUNT_SEGMENT26 = decode(icx_charge_acct_seg26,
1290: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT26,
1291: icx_charge_acct_seg26),

Line 1290: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT26,

1286: CHARGE_ACCOUNT_SEGMENT25 = decode(icx_charge_acct_seg25,
1287: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT25,
1288: icx_charge_acct_seg25),
1289: CHARGE_ACCOUNT_SEGMENT26 = decode(icx_charge_acct_seg26,
1290: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT26,
1291: icx_charge_acct_seg26),
1292: CHARGE_ACCOUNT_SEGMENT27 = decode(icx_charge_acct_seg27,
1293: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT27,
1294: icx_charge_acct_seg27),

Line 1293: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT27,

1289: CHARGE_ACCOUNT_SEGMENT26 = decode(icx_charge_acct_seg26,
1290: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT26,
1291: icx_charge_acct_seg26),
1292: CHARGE_ACCOUNT_SEGMENT27 = decode(icx_charge_acct_seg27,
1293: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT27,
1294: icx_charge_acct_seg27),
1295: CHARGE_ACCOUNT_SEGMENT28 = decode(icx_charge_acct_seg28,
1296: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT28,
1297: icx_charge_acct_seg28),

Line 1296: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT28,

1292: CHARGE_ACCOUNT_SEGMENT27 = decode(icx_charge_acct_seg27,
1293: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT27,
1294: icx_charge_acct_seg27),
1295: CHARGE_ACCOUNT_SEGMENT28 = decode(icx_charge_acct_seg28,
1296: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT28,
1297: icx_charge_acct_seg28),
1298: CHARGE_ACCOUNT_SEGMENT29 = decode(icx_charge_acct_seg29,
1299: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT29,
1300: icx_charge_acct_seg29),

Line 1299: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT29,

1295: CHARGE_ACCOUNT_SEGMENT28 = decode(icx_charge_acct_seg28,
1296: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT28,
1297: icx_charge_acct_seg28),
1298: CHARGE_ACCOUNT_SEGMENT29 = decode(icx_charge_acct_seg29,
1299: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT29,
1300: icx_charge_acct_seg29),
1301: CHARGE_ACCOUNT_SEGMENT30 = decode(icx_charge_acct_seg30,
1302: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT30,
1303: icx_charge_acct_seg30)

Line 1302: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT30,

1298: CHARGE_ACCOUNT_SEGMENT29 = decode(icx_charge_acct_seg29,
1299: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT29,
1300: icx_charge_acct_seg29),
1301: CHARGE_ACCOUNT_SEGMENT30 = decode(icx_charge_acct_seg30,
1302: FND_API.G_MISS_CHAR, CHARGE_ACCOUNT_SEGMENT30,
1303: icx_charge_acct_seg30)
1304: where
1305: cart_id = v_cart_id;
1306:

Line 1319: if (icx_deliver_to_location <> FND_API.G_MISS_CHAR) then

1315:
1316:
1317:
1318: -- Location Location Location
1319: if (icx_deliver_to_location <> FND_API.G_MISS_CHAR) then
1320: --deliver to location on at the Header level, make sure its correct
1321: if (icx_deliver_to_location_id is null) then
1322: -- the user typed the value into the field, we have to validate
1323: open get_loc_org_id(icx_deliver_to_location);

Line 1378: if (icx_deliver_to_requestor <> FND_API.G_MISS_CHAR) then

1374: and SHOPPER_ID = v_shopper_id;
1375: end if;
1376:
1377: --validate requster
1378: if (icx_deliver_to_requestor <> FND_API.G_MISS_CHAR) then
1379: -- requster must be on in the region
1380: if (icx_deliver_to_requestor_id is null) then
1381: -- user type in value for requester
1382: if (icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG')

Line 1435: if (icx_approver_name <> FND_API.G_MISS_CHAR) then

1431: and SHOPPER_ID = v_shopper_id;
1432: end if;
1433:
1434: --validate approver
1435: if (icx_approver_name <> FND_API.G_MISS_CHAR) then
1436: -- approver must be in the region
1437: if (icx_approver_id is null) then
1438: -- user typed in an approver
1439: open employee_check(icx_approver_name);

Line 2052: if (icx_deliver_to_location <> FND_API.G_MISS_CHAR) then

2048: and CART_ID = v_cart_id;
2049:
2050: else
2051: -- if location on at parent copy org from the parent
2052: if (icx_deliver_to_location <> FND_API.G_MISS_CHAR) then
2053: update icx_shopping_cart_lines
2054: set (DELIVER_TO_LOCATION_ID, DESTINATION_ORGANIZATION_ID,
2055: DELIVER_TO_LOCATION) =
2056: (select DELIVER_TO_LOCATION_ID,