APPS.CST_SUBELEMENTS_PVT dependencies on CST_ACTIVITIES

Line 451: from cst_activities

447:
448: l_statement := 110;
449: select count(*)
450: into l_exists
451: from cst_activities
452: where activity = activity_rec.activity
453: and nvl(organization_id,p_to_organization_id) = p_to_organization_id;
454:
455: l_statement := 120;

Line 472: from cst_activities

468:
469: l_statement := 140;
470: select activity_id
471: into l_current_rec.ID
472: from cst_activities
473: where organization_id = p_from_organization_id
474: and activity = l_current_rec.code;
475:
476: l_statement := 150;

Line 671: -- cst_activities

667:
668: END IF;
669:
670: ----------------------------------------------------------------------
671: -- cst_activities
672: ----------------------------------------------------------------------
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'activity count : '
674: || TO_CHAR(p_activity_count));
675:

Line 687: FROM cst_activities ca

683: l_statement := 40;
684:
685: SELECT MAX(activity)
686: INTO l_activity
687: FROM cst_activities ca
688: WHERE ca.activity_id = l_source_activity_id
689: AND ca.organization_id = p_from_organization_id;
690:
691:

Line 704: INSERT INTO cst_activities

700: ------------------------------------------------------------------------
701:
702: l_statement := 50;
703:
704: INSERT INTO cst_activities
705: (
706: activity_id,
707: last_update_date,
708: last_updated_by,

Line 741: cst_activities_s.nextval,

737: program_id,
738: program_update_date
739: )
740: SELECT
741: cst_activities_s.nextval,
742: SYSDATE,
743: l_user_id,
744: SYSDATE,
745: l_user_id,

Line 774: FROM cst_activities ca

770: l_request_id,
771: l_prog_app_id,
772: l_prog_id,
773: SYSDATE
774: FROM cst_activities ca
775: WHERE ca.activity_id = l_source_activity_id
776: AND ca.organization_id = p_from_organization_id
777: AND NOT EXISTS ( SELECT 'X'
778: FROM cst_activities ca2

Line 778: FROM cst_activities ca2

774: FROM cst_activities ca
775: WHERE ca.activity_id = l_source_activity_id
776: AND ca.organization_id = p_from_organization_id
777: AND NOT EXISTS ( SELECT 'X'
778: FROM cst_activities ca2
779: WHERE ca2.organization_id = p_to_organization_id
780: AND ca2.activity = l_activity) ;
781:
782: IF (SQL%ROWCOUNT) > 0 THEN

Line 1240: FROM cst_activities ca

1236: l_statement := 220;
1237:
1238: SELECT MAX(activity_id)
1239: INTO l_dummy
1240: FROM cst_activities ca
1241: WHERE ca.activity =
1242: ( SELECT ca2.activity
1243: FROM cst_activities ca2
1244: WHERE ca2.activity_id = l_default_activity_id)

Line 1243: FROM cst_activities ca2

1239: INTO l_dummy
1240: FROM cst_activities ca
1241: WHERE ca.activity =
1242: ( SELECT ca2.activity
1243: FROM cst_activities ca2
1244: WHERE ca2.activity_id = l_default_activity_id)
1245: AND (ca.organization_id = p_to_organization_id OR
1246: ca.organization_id IS NULL);
1247:

Line 2367: CST_ACTIVITIES CA

2363: CA.ACTIVITY
2364: INTO l_material_subelement_code,
2365: l_mat_activity
2366: FROM BOM_RESOURCES BR,
2367: CST_ACTIVITIES CA
2368: WHERE BR.RESOURCE_ID = p_material_subelement
2369: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2370: end if;
2371:

Line 2379: CST_ACTIVITIES CA

2375: CA.ACTIVITY
2376: INTO l_moh_subelement_code,
2377: l_moh_activity
2378: FROM BOM_RESOURCES BR,
2379: CST_ACTIVITIES CA
2380: WHERE BR.RESOURCE_ID = p_moh_subelement
2381: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2382: end if;
2383:

Line 2391: CST_ACTIVITIES CA

2387: CA.ACTIVITY
2388: INTO l_resource_subelement_code,
2389: l_res_activity
2390: FROM BOM_RESOURCES BR,
2391: CST_ACTIVITIES CA
2392: WHERE BR.RESOURCE_ID = p_resource_subelement
2393: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2394: end if;
2395:

Line 2403: CST_ACTIVITIES CA

2399: CA.ACTIVITY
2400: INTO l_osp_subelement_code,
2401: l_osp_activity
2402: FROM BOM_RESOURCES BR,
2403: CST_ACTIVITIES CA
2404: WHERE BR.RESOURCE_ID = p_osp_subelement
2405: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2406: end if;
2407:

Line 2415: CST_ACTIVITIES CA

2411: CA.ACTIVITY
2412: INTO l_overhead_subelement_code,
2413: l_ovh_activity
2414: FROM BOM_RESOURCES BR,
2415: CST_ACTIVITIES CA
2416: WHERE BR.RESOURCE_ID = p_overhead_subelement
2417: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2418: end if;
2419: