[Home] [Help]
1009:
1010: cursor c_cp_status(p_transaction_type_id number) is
1011: select ctst.src_status_id
1012: from csi_txn_sub_types ctst ,
1013: cs_transaction_types_vl cttv
1014: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1015: AND cttv.transaction_type_id = p_transaction_type_id;
1016:
1017: cursor c_cp_status_notnull (p_cp_status varchar2) is
1027: cursor c_txn_billing_type_id (p_txn_billing_type_id number) is
1028: select ctbt.billing_type,
1029: cttv.line_order_category_code,
1030: cttv.transaction_type_id
1031: from cs_transaction_types_vl cttv,
1032: cs_txn_billing_types ctbt
1033: where ctbt.txn_billing_type_id = p_txn_billing_type_id
1034: and ctbt.transaction_type_id = cttv.transaction_type_id;
1035:
1036: cursor c_transaction_type_id (p_transaction_type_id number,
1037: p_inventory_item_id number) is
1038: select ctbt.billing_type,
1039: cttv.line_order_category_code
1040: from cs_transaction_types_vl cttv,
1041: cs_txn_billing_types ctbt,
1042: mtl_system_items_b_kfv msibk
1043: where cttv.transaction_type_id = p_transaction_type_id
1044: and cttv.transaction_type_id = ctbt.transaction_type_id
1886:
1887: cursor c_cp_status(p_transaction_type_id number) is
1888: select ctst.src_status_id
1889: from csi_txn_sub_types ctst ,
1890: cs_transaction_types_vl cttv
1891: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1892: and cttv.transaction_type_id = p_transaction_type_id;
1893:
1894: cursor c_cp_status_notnull (p_cp_status varchar2) is
2775: IS
2776: l_dummy number;
2777: cursor get_transaction_type_id is
2778: select 1
2779: from cs_transaction_types vl
2780: where transaction_type_id=P_Transaction_type_id;
2781: BEGIN
2782: -- Initialize message list if p_init_msg_list is set to TRUE.
2783: IF FND_API.to_Boolean( p_init_msg_list )
3366: cursor c_travel_exists(p_task_assignment_id number) is
3367: select 'Y'
3368: from csf_debrief_headers cdh,
3369: csf_debrief_lines cdl,
3370: cs_transaction_types ctt,
3371: cs_txn_billing_types ctbt
3372: where cdh.task_assignment_id = p_task_assignment_id
3373: and cdl.debrief_header_id = cdh.debrief_header_id
3374: and ctt.transaction_type_id = cdl.transaction_type_id
3379: cursor c_working_exists(p_task_assignment_id number) is
3380: select 'Y'
3381: from csf_debrief_headers cdh,
3382: csf_debrief_lines cdl,
3383: cs_transaction_types ctt,
3384: cs_txn_billing_types ctbt
3385: where cdh.task_assignment_id = p_task_assignment_id
3386: and cdl.debrief_header_id = cdh.debrief_header_id
3387: and ctt.transaction_type_id = cdl.transaction_type_id
3765: select min(labor_start_date),
3766: max(labor_end_date),
3767: min(debrief_line_id)
3768: from csf_debrief_lines cdl,
3769: cs_transaction_types ctt
3770: where cdl.debrief_header_id = p_debrief_header_id
3771: and cdl.transaction_type_id = ctt.transaction_type_id
3772: and ctt.line_order_category_code = 'ORDER';
3773:
3775: select min(labor_start_date),
3776: max(labor_end_date),
3777: min(debrief_line_id)
3778: from csf_debrief_lines cdl,
3779: cs_transaction_types ctt
3780: where cdl.debrief_header_id = p_debrief_header_id
3781: and cdl.transaction_type_id = ctt.transaction_type_id
3782: and ctt.line_order_category_code = 'RETURN'
3783: and cdl.labor_start_date between p_start_date_order and p_end_date_order
3789: min(debrief_line_id)
3790: from csf_debrief_lines cdl,
3791: csf_debrief_headers cdh,
3792: jtf_task_assignments jta,
3793: cs_transaction_types ctt
3794: where jta.task_id = l_task_id
3795: and jta.task_assignment_id = cdh.task_assignment_id
3796: and cdh.debrief_header_id = cdl.debrief_header_id
3797: and cdl.transaction_type_id = ctt.transaction_type_id
3803: min(debrief_line_id)
3804: from csf_debrief_lines cdl,
3805: csf_debrief_headers cdh,
3806: jtf_task_assignments jta,
3807: cs_transaction_types ctt
3808: where jta.task_id = l_task_id
3809: and jta.task_assignment_id = cdh.task_assignment_id
3810: and cdh.debrief_header_id = cdl.debrief_header_id
3811: and cdl.transaction_type_id = ctt.transaction_type_id
3819: from csf_debrief_lines cdl,
3820: csf_debrief_headers cdh,
3821: jtf_task_assignments jta,
3822: jtf_tasks_b jtb,
3823: cs_transaction_types ctt
3824: where jtb.parent_task_id = l_parent_task_id
3825: and jta.task_id = jtb.task_id
3826: and jta.task_assignment_id = cdh.task_assignment_id
3827: and cdh.debrief_header_id = cdl.debrief_header_id
3834: from csf_debrief_lines cdl,
3835: csf_debrief_headers cdh,
3836: jtf_task_assignments jta,
3837: jtf_tasks_b jtb,
3838: cs_transaction_types ctt
3839: where jtb.parent_task_id = l_parent_task_id
3840: and jta.task_id = jtb.task_id
3841: and jta.task_assignment_id = cdh.task_assignment_id
3842: and cdh.debrief_header_id = cdl.debrief_header_id
3854: select uom_code, quantity
3855: from jtf_task_assignments jta,
3856: csf_debrief_headers cdh,
3857: csf_debrief_lines cdl,
3858: cs_transaction_types ctt
3859: where cdh.debrief_header_id = cdl.debrief_header_id
3860: and jta.task_assignment_id = cdh.task_assignment_id
3861: and cdh.debrief_header_id = p_debrief_header_id
3862: and cdl.transaction_type_id = ctt.transaction_type_id
3873: select uom_code, (quantity * -1)
3874: from jtf_task_assignments jta,
3875: csf_debrief_headers cdh,
3876: csf_debrief_lines cdl,
3877: cs_transaction_types ctt
3878: where cdh.debrief_header_id = cdl.debrief_header_id
3879: and jta.task_assignment_id = cdh.task_assignment_id
3880: and cdh.debrief_header_id = p_debrief_header_id
3881: and cdl.transaction_type_id = ctt.transaction_type_id
3894: from csf_debrief_lines cdl,
3895: csf_debrief_headers cdh,
3896: jtf_task_assignments jta,
3897: jtf_tasks_b jtb,
3898: cs_transaction_types ctt
3899: where cdh.debrief_header_id = cdl.debrief_header_id
3900: and jta.task_assignment_id = cdh.task_assignment_id
3901: and cdl.transaction_type_id = ctt.transaction_type_id
3902: and ctt.line_order_category_code = 'ORDER'
3915: from csf_debrief_lines cdl,
3916: csf_debrief_headers cdh,
3917: jtf_task_assignments jta,
3918: jtf_tasks_b jtb,
3919: cs_transaction_types ctt
3920: where cdh.debrief_header_id = cdl.debrief_header_id
3921: and jta.task_assignment_id = cdh.task_assignment_id
3922: and cdl.transaction_type_id = ctt.transaction_type_id
3923: and ctt.line_order_category_code = 'RETURN'
3937: from csf_debrief_lines cdl,
3938: csf_debrief_headers cdh,
3939: jtf_task_assignments jta,
3940: jtf_tasks_b jtb,
3941: cs_transaction_types ctt
3942: where cdh.debrief_header_id = cdl.debrief_header_id
3943: and jta.task_assignment_id = cdh.task_assignment_id
3944: and cdl.transaction_type_id = ctt.transaction_type_id
3945: and ctt.line_order_category_code = 'ORDER'
3958: from csf_debrief_lines cdl,
3959: csf_debrief_headers cdh,
3960: jtf_task_assignments jta,
3961: jtf_tasks_b jtb,
3962: cs_transaction_types ctt
3963: where cdh.debrief_header_id = cdl.debrief_header_id
3964: and jta.task_assignment_id = cdh.task_assignment_id
3965: and cdl.transaction_type_id = ctt.transaction_type_id
3966: and ctt.line_order_category_code = 'RETURN'