1028: x_org_id number;
1029:
1030: cursor c1 is
1031: select organization_id
1032: from csd_repair_job_xref crjx
1033: where wip_entity_id = p_txn_source_id
1034: order by repair_job_xref_id desc;
1035:
1036: begin
1067: x_acct_id number;
1068:
1069: cursor c1 is
1070: select repair_line_id
1071: from csd_repair_job_xref
1072: where wip_entity_id = p_txn_source_id
1073: order by repair_job_xref_id desc;
1074:
1075: cursor c2 (p_repair_line_id in number) is
1131: x_zone_id number;
1132:
1133: cursor c1 is
1134: select repair_line_id
1135: from csd_repair_job_xref
1136: where wip_entity_id = p_txn_source_id
1137: order by repair_job_xref_id desc;
1138:
1139: cursor c2 (p_repair_line_id in number) is
1176:
1177: x_row_num number;
1178: cursor c1 is
1179: select 1
1180: from csd_repair_job_xref crjx
1181: where wip_entity_id = p_txn_source_id
1182: order by repair_job_xref_id;
1183:
1184: begin