eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_TERRITORY_PUB

Line 2692: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;

2688: l_current_record INTEGER := 0;
2689: l_current_rec INTEGER := 0;
2690: l_pref_record INTEGER := 0;
2691:
2692: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2693: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2694: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2695:
2696: l_engineer_id JTF_NUMBER_TABLE;

Line 2693: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

2689: l_current_rec INTEGER := 0;
2690: l_pref_record INTEGER := 0;
2691:
2692: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2693: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2694: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2695:
2696: l_engineer_id JTF_NUMBER_TABLE;
2697: l_resource_type JTF_VARCHAR2_TABLE_100;

Line 2694: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

2690: l_pref_record INTEGER := 0;
2691:
2692: l_assign_resources_rec JTF_TERRITORY_PUB.JTF_Task_Rec_Type;
2693: l_assign_resources_sr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
2694: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
2695:
2696: l_engineer_id JTF_NUMBER_TABLE;
2697: l_resource_type JTF_VARCHAR2_TABLE_100;
2698:

Line 3662: -- p_sr_rec JTF_TERRITORY_PUB.

3658:
3659:
3660: -- These parameters contain the Qualifier Values for
3661: -- the Calling Document
3662: -- p_sr_rec JTF_TERRITORY_PUB.
3663: -- JTF_Serv_Req_rec_type
3664: -- p_sr_task_rec JTF_TERRITORY_PUB.
3665: -- JTF_Srv_Task_rec_type
3666:

Line 3664: -- p_sr_task_rec JTF_TERRITORY_PUB.

3660: -- These parameters contain the Qualifier Values for
3661: -- the Calling Document
3662: -- p_sr_rec JTF_TERRITORY_PUB.
3663: -- JTF_Serv_Req_rec_type
3664: -- p_sr_task_rec JTF_TERRITORY_PUB.
3665: -- JTF_Srv_Task_rec_type
3666:
3667:
3668: -- OUT : x_return_status OUT VARCHAR2(1)

Line 3714: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,

3710: p_inventory_item_id IN NUMBER,
3711: p_inventory_org_id IN NUMBER,
3712: p_problem_code IN VARCHAR2 ,
3713: p_sr_id IN NUMBER,
3714: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
3715: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
3716: p_business_process_id IN NUMBER,
3717: p_business_process_date IN DATE,
3718: p_filter_excluded_resource IN VARCHAR2,

Line 3715: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,

3711: p_inventory_org_id IN NUMBER,
3712: p_problem_code IN VARCHAR2 ,
3713: p_sr_id IN NUMBER,
3714: p_sr_rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
3715: p_sr_task_rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
3716: p_business_process_id IN NUMBER,
3717: p_business_process_date IN DATE,
3718: p_filter_excluded_resource IN VARCHAR2,
3719: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

Line 3756: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

3752: l_current_record INTEGER;
3753: l_current_rec INTEGER := 0;
3754: l_pref_record INTEGER := 0;
3755:
3756: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
3757: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
3758:
3759:
3760: l_return_status VARCHAR2(10);

Line 5166: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

5162:
5163: l_bind_data_id NUMBER;
5164: l_workflow_key NUMBER;
5165:
5166: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
5167: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5168: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5169: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
5170:

Line 5169: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

5165:
5166: l_dr_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
5167: l_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5168: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
5169: l_winningterrmember_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
5170:
5171: l_dr_id NUMBER;
5172: l_p_resource_type VARCHAR2(30) := p_resource_type;
5173: l_planned_start_date DATE;

Line 6642: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

6638: l_return_code VARCHAR2(60);
6639: l_bind_data_id NUMBER;
6640: l_workflow_key NUMBER;
6641:
6642: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
6643: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
6644:
6645: l_x_planned_start_date DATE;
6646: l_x_planned_end_date DATE;

Line 6643: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;

6639: l_bind_data_id NUMBER;
6640: l_workflow_key NUMBER;
6641:
6642: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
6643: l_opportunity_rec JTF_TERRITORY_PUB.JTF_Oppor_rec_type;
6644:
6645: l_x_planned_start_date DATE;
6646: l_x_planned_end_date DATE;
6647: l_x_shift_construct_id NUMBER;

Line 7261: -- p_lead_rec JTF_TERRITORY_PUB.

7257:
7258:
7259: -- This parameter contains the values of the Qualifiers
7260: -- defined for the Sales Leads.
7261: -- p_lead_rec JTF_TERRITORY_PUB.
7262: -- JTF_Lead_BULK_rec_type
7263: -- REQUIRED
7264:
7265: -- OUT : x_return_status OUT VARCHAR2(1)

Line 7301: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,

7297: p_start_date IN DATE ,
7298: p_end_date IN DATE ,
7299: p_territory_flag IN VARCHAR2,
7300: p_calendar_flag IN VARCHAR2,
7301: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
7302: -- x_assign_resources_bulk_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
7303: p_business_process_id IN NUMBER,
7304: p_business_process_date IN DATE,
7305: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

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

7298: p_end_date IN DATE ,
7299: p_territory_flag IN VARCHAR2,
7300: p_calendar_flag IN VARCHAR2,
7301: p_lead_rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
7302: -- x_assign_resources_bulk_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
7303: p_business_process_id IN NUMBER,
7304: p_business_process_date IN DATE,
7305: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
7306: x_return_status OUT NOCOPY VARCHAR2,

Line 7334: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;

7330: l_return_code VARCHAR2(60);
7331: l_bind_data_id NUMBER;
7332: l_workflow_key NUMBER;
7333:
7334: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7335: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7336: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7337:
7338: l_x_planned_start_date DATE;

Line 7335: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;

7331: l_bind_data_id NUMBER;
7332: l_workflow_key NUMBER;
7333:
7334: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7335: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7336: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7337:
7338: l_x_planned_start_date DATE;
7339: l_x_planned_end_date DATE;

Line 7336: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

7332: l_workflow_key NUMBER;
7333:
7334: l_assign_resources_bulk_rec JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE;
7335: --l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type;
7336: --l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7337:
7338: l_x_planned_start_date DATE;
7339: l_x_planned_end_date DATE;
7340: l_x_shift_construct_id NUMBER;

Line 7875: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

7871: l_return_code VARCHAR2(60);
7872: l_bind_data_id NUMBER;
7873: l_workflow_key NUMBER;
7874:
7875: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7876: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;
7877:
7878: l_x_planned_start_date DATE;
7879: l_x_planned_end_date DATE;

Line 7876: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;

7872: l_bind_data_id NUMBER;
7873: l_workflow_key NUMBER;
7874:
7875: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
7876: l_lead_rec JTF_TERRITORY_PUB.JTF_Lead_rec_type;
7877:
7878: l_x_planned_start_date DATE;
7879: l_x_planned_end_date DATE;
7880: l_x_shift_construct_id NUMBER;

Line 8537: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

8533: l_return_code VARCHAR2(60);
8534: l_bind_data_id NUMBER;
8535: l_workflow_key NUMBER;
8536:
8537: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
8538: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
8539:
8540: l_x_planned_start_date DATE;
8541: l_x_planned_end_date DATE;

Line 8538: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;

8534: l_bind_data_id NUMBER;
8535: l_workflow_key NUMBER;
8536:
8537: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
8538: l_account_rec JTF_TERRITORY_PUB.JTF_Account_rec_type;
8539:
8540: l_x_planned_start_date DATE;
8541: l_x_planned_end_date DATE;
8542: l_x_shift_construct_id NUMBER;

Line 9114: -- p_defect_rec JTF_TERRITORY_PUB.

9110:
9111:
9112: -- This parameter contains the Qualifier Values
9113: -- of the Calling Document
9114: -- p_defect_rec JTF_TERRITORY_PUB.
9115: -- JTF_DEF_MGMT_rec_type
9116:
9117:
9118: -- OUT : x_return_status OUT VARCHAR2(1)

Line 9153: p_defect_rec IN JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type,

9149: p_start_date IN DATE,
9150: p_end_date IN DATE,
9151: p_territory_flag IN VARCHAR2,
9152: p_calendar_flag IN VARCHAR2,
9153: p_defect_rec IN JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type,
9154: p_business_process_id IN NUMBER,
9155: p_business_process_date IN DATE,
9156: x_assign_resources_tbl OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
9157: x_return_status OUT NOCOPY VARCHAR2,

Line 9174: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;

9170:
9171: l_current_record INTEGER;
9172: l_total_records INTEGER;
9173:
9174: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
9175: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;
9176:
9177: l_x_planned_start_date DATE;
9178: l_x_planned_end_date DATE;

Line 9175: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;

9171: l_current_record INTEGER;
9172: l_total_records INTEGER;
9173:
9174: l_assign_resources_tbl JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
9175: -- l_assign_resources_rec JTF_TERRITORY_PUB.JTF_DEF_MGMT_rec_type;
9176:
9177: l_x_planned_start_date DATE;
9178: l_x_planned_end_date DATE;
9179: l_x_shift_construct_id NUMBER;

Line 10778: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;

10774:
10775: l_bind_data_id NUMBER;
10776: l_workflow_key NUMBER;
10777:
10778: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10779: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10780: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10781: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10782: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896

Line 10779: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;

10775: l_bind_data_id NUMBER;
10776: l_workflow_key NUMBER;
10777:
10778: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10779: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10780: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10781: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10782: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896
10783:

Line 10780: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;

10776: l_workflow_key NUMBER;
10777:
10778: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
10779: l_sr_task_rec JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type;
10780: l_defect_rec JTF_TERRITORY_PUB.JTF_Def_Mgmt_rec_type;
10781: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
10782: t_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type; --6453896
10783:
10784: