DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_TERRITORY_PUB

Line 2655: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;

2651: l_current_record INTEGER := 0;
2652: l_current_rec INTEGER := 0;
2653: l_pref_record INTEGER := 0;
2654:
2655: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2656: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2657: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2658:
2659: l_engineer_id JTF_NUMBER_TABLE;

Line 2656: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

2652: l_current_rec INTEGER := 0;
2653: l_pref_record INTEGER := 0;
2654:
2655: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2656: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2657: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2658:
2659: l_engineer_id JTF_NUMBER_TABLE;
2660: l_resource_type JTF_VARCHAR2_TABLE_100;

Line 2657: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

2653: l_pref_record INTEGER := 0;
2654:
2655: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2656: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2657: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2658:
2659: l_engineer_id JTF_NUMBER_TABLE;
2660: l_resource_type JTF_VARCHAR2_TABLE_100;
2661:

Line 3625: -- p_sr_rec JTF_TERRITORY_PUB.

3621:
3622:
3623: -- These parameters contain the Qualifier Values for
3624: -- the Calling Document
3625: -- p_sr_rec JTF_TERRITORY_PUB.
3626: -- JTF_Serv_Req_rec_type
3627: -- p_sr_task_rec JTF_TERRITORY_PUB.
3628: -- JTF_Srv_Task_rec_type
3629:

Line 3627: -- p_sr_task_rec JTF_TERRITORY_PUB.

3623: -- These parameters contain the Qualifier Values for
3624: -- the Calling Document
3625: -- p_sr_rec JTF_TERRITORY_PUB.
3626: -- JTF_Serv_Req_rec_type
3627: -- p_sr_task_rec JTF_TERRITORY_PUB.
3628: -- JTF_Srv_Task_rec_type
3629:
3630:
3631: -- OUT : x_return_status OUT VARCHAR2(1)

Line 3677: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,

3673: p_inventory_item_id IN NUMBER,
3674: p_inventory_org_id IN NUMBER,
3675: p_problem_code IN VARCHAR2 ,
3676: p_sr_id IN NUMBER,
3677: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
3678: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
3679: p_business_process_id IN NUMBER,
3680: p_business_process_date IN DATE,
3681: p_filter_excluded_resource IN VARCHAR2,

Line 3678: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,

3674: p_inventory_org_id IN NUMBER,
3675: p_problem_code IN VARCHAR2 ,
3676: p_sr_id IN NUMBER,
3677: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
3678: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
3679: p_business_process_id IN NUMBER,
3680: p_business_process_date IN DATE,
3681: p_filter_excluded_resource IN VARCHAR2,
3682: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

Line 3719: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

3715: l_current_record INTEGER;
3716: l_current_rec INTEGER := 0;
3717: l_pref_record INTEGER := 0;
3718:
3719: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
3720: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
3721:
3722:
3723: l_return_status VARCHAR2(10);

Line 5102: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

5098:
5099: l_bind_data_id NUMBER;
5100: l_workflow_key NUMBER;
5101:
5102: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
5103: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5104: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5105: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
5106:

Line 5105: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

5101:
5102: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
5103: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5104: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5105: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
5106:
5107: l_dr_id NUMBER;
5108: l_p_resource_type VARCHAR2(30) := p_resource_type;
5109: l_planned_start_date DATE;

Line 6578: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

6574: l_return_code VARCHAR2(60);
6575: l_bind_data_id NUMBER;
6576: l_workflow_key NUMBER;
6577:
6578: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
6579: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
6580:
6581: l_x_planned_start_date DATE;
6582: l_x_planned_end_date DATE;

Line 6579: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;

6575: l_bind_data_id NUMBER;
6576: l_workflow_key NUMBER;
6577:
6578: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
6579: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
6580:
6581: l_x_planned_start_date DATE;
6582: l_x_planned_end_date DATE;
6583: l_x_shift_construct_id NUMBER;

Line 7197: -- p_lead_rec JTF_TERRITORY_PUB.

7193:
7194:
7195: -- This parameter contains the values of the Qualifiers
7196: -- defined for the Sales Leads.
7197: -- p_lead_rec JTF_TERRITORY_PUB.
7198: -- JTF_Lead_BULK_rec_type
7199: -- REQUIRED
7200:
7201: -- OUT : x_return_status OUT VARCHAR2(1)

Line 7237: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,

7233: p_start_date IN DATE ,
7234: p_end_date IN DATE ,
7235: p_territory_flag IN VARCHAR2,
7236: p_calendar_flag IN VARCHAR2,
7237: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
7238: -- x_assign_resources_bulk_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
7239: p_business_process_id IN NUMBER,
7240: p_business_process_date IN DATE,
7241: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

Line 7238: -- x_assign_resources_bulk_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,

7234: p_end_date IN DATE ,
7235: p_territory_flag IN VARCHAR2,
7236: p_calendar_flag IN VARCHAR2,
7237: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
7238: -- x_assign_resources_bulk_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
7239: p_business_process_id IN NUMBER,
7240: p_business_process_date IN DATE,
7241: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
7242: x_return_status OUT NOCOPY VARCHAR2,

Line 7270: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;

7266: l_return_code VARCHAR2(60);
7267: l_bind_data_id NUMBER;
7268: l_workflow_key NUMBER;
7269:
7270: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7271: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7272: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7273:
7274: l_x_planned_start_date DATE;

Line 7271: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;

7267: l_bind_data_id NUMBER;
7268: l_workflow_key NUMBER;
7269:
7270: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7271: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7272: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7273:
7274: l_x_planned_start_date DATE;
7275: l_x_planned_end_date DATE;

Line 7272: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

7268: l_workflow_key NUMBER;
7269:
7270: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7271: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7272: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7273:
7274: l_x_planned_start_date DATE;
7275: l_x_planned_end_date DATE;
7276: l_x_shift_construct_id NUMBER;

Line 7811: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

7807: l_return_code VARCHAR2(60);
7808: l_bind_data_id NUMBER;
7809: l_workflow_key NUMBER;
7810:
7811: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7812: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;
7813:
7814: l_x_planned_start_date DATE;
7815: l_x_planned_end_date DATE;

Line 7812: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;

7808: l_bind_data_id NUMBER;
7809: l_workflow_key NUMBER;
7810:
7811: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7812: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;
7813:
7814: l_x_planned_start_date DATE;
7815: l_x_planned_end_date DATE;
7816: l_x_shift_construct_id NUMBER;

Line 8473: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

8469: l_return_code VARCHAR2(60);
8470: l_bind_data_id NUMBER;
8471: l_workflow_key NUMBER;
8472:
8473: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
8474: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
8475:
8476: l_x_planned_start_date DATE;
8477: l_x_planned_end_date DATE;

Line 8474: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;

8470: l_bind_data_id NUMBER;
8471: l_workflow_key NUMBER;
8472:
8473: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
8474: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
8475:
8476: l_x_planned_start_date DATE;
8477: l_x_planned_end_date DATE;
8478: l_x_shift_construct_id NUMBER;

Line 9050: -- p_defect_rec JTF_TERRITORY_PUB.

9046:
9047:
9048: -- This parameter contains the Qualifier Values
9049: -- of the Calling Document
9050: -- p_defect_rec JTF_TERRITORY_PUB.
9051: -- JTF_DEF_MGMT_rec_type
9052:
9053:
9054: -- OUT : x_return_status OUT VARCHAR2(1)

Line 9089: p_defect_rec IN JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type,

9085: p_start_date IN DATE,
9086: p_end_date IN DATE,
9087: p_territory_flag IN VARCHAR2,
9088: p_calendar_flag IN VARCHAR2,
9089: p_defect_rec IN JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type,
9090: p_business_process_id IN NUMBER,
9091: p_business_process_date IN DATE,
9092: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
9093: x_return_status OUT NOCOPY VARCHAR2,

Line 9110: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

9106:
9107: l_current_record INTEGER;
9108: l_total_records INTEGER;
9109:
9110: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
9111: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;
9112:
9113: l_x_planned_start_date DATE;
9114: l_x_planned_end_date DATE;

Line 9111: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;

9107: l_current_record INTEGER;
9108: l_total_records INTEGER;
9109:
9110: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
9111: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;
9112:
9113: l_x_planned_start_date DATE;
9114: l_x_planned_end_date DATE;
9115: l_x_shift_construct_id NUMBER;

Line 10714: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;

10710:
10711: l_bind_data_id NUMBER;
10712: l_workflow_key NUMBER;
10713:
10714: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10715: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10716: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10717: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10718: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896

Line 10715: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

10711: l_bind_data_id NUMBER;
10712: l_workflow_key NUMBER;
10713:
10714: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10715: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10716: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10717: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10718: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896
10719:

Line 10716: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;

10712: l_workflow_key NUMBER;
10713:
10714: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10715: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10716: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10717: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10718: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896
10719:
10720: